Monday, September 10, 2012

odi-15050 flow control not possible if no key is declared in your target datastore

odi-15050 flow control not possible if no key is declared in your target datastore


Solution:
----------

In your interface target table don't have Primary Key or Unique Key.

Two ways we can resolve this issue.

1) Goto=> Interface=>QuickEdit=>Mappings

select one any id (ex: EMPNO) UK.






2)

Goto =>Models=UR Model(TARGET_SQL_MODEL)=>EMP(table)=>Constraints=>

Right click =>New Key=>Select Primary Key=>Got To =>Columns=>Move EMPNO to right side.