4 Replies Latest reply: Apr 13, 2012 10:55 AM by 774570 RSS

    ODI Error: no Key is declared in your Target Datastore

      Hi All

      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?

      Thanks in advance