Troubleshooting Flow & Static Controls in ODI

  • If in the Constraints Node, under the Controls tab, the  flow and static controls are checked, but in the Interface under Flow tab the Flow and Static Controls are set to No,  after executing the interface the error table is not created and the target table is not populated.
  • If in the Constraints Node, under the Controls tab, the  flow and static controls are checked, but in the Interface  under Flow tab the Flow control is set to Yes and Static Controls is set to No,  after executing the interface the error table is created but not populated and the target table is not populated.
  • If in the Constraints Node, under the Controls tab, the  flow and static controls are checked, but in the Interface  under Flow tab the Flow control is set to No and Static Controls is set to Yes,  after executing the interface the error table is not created and the target table is not populated.
Advertisements