Sunday, December 9, 2012

Oracle Data Integrator: Error: 15050 "Flow control not possible if no key is declared in your target datastore"

This may be the result of interface not having a Primary Key (PK) or Unique Key (UK).
You may try these alternatives to solve the problem:

1. Go to Interface > Quick Edit > Mappings
2. Select one an ID; i.e. EMPNO as a UK.

 

OR – you can perform this:

1. Go to > Models, i.e. TARGET_SQL_MODEL > EMP [table] > Constraints
2. Right click on Constraints > New Key > Select Primary Key > Go To > Columns > Move EMPNO to right side.




Hope this helped and feedback is welcomed! 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.