I am trying to update a field in a table (MSSQL database) from fields in the same table using the IKM MSSQL Incremental Update.
When I try to run the interface the following error occurs:
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Flow Control not possible if no Key is declared in your Target Datastore
I have selected the 'Key' option on the primary key field in the 'Target Column Properties' on the Mapping tab in Designer, but when i select the 'Update Key' in the Flow tab, there are no fields to select.
What is the difference between these two key configurations in Designer? Why isn't ODI recognizing the key specified on the target?
You need to create a PK by adding constraint in ur target "data store" (Go to Models-> Your target Data store-> expand it, Right click on Constraints-> New Key and select ur PK in the Columns tab). Then u can see the PK in the drop down list of Update Key.
Also, FLOW_CONTROL has to be enabled if u need to to have "error capturing" mechanism (E$) etc, if not u can set it to FALSE.