Your Code is Doing Some cartesian with Some Source.
Check name of that source which creating problem while saving object.
If this is not resolved you may not access to FLOW tab.
Critical : DataSet Default : All datastores in a dataset should be joined. This dataset has several sets of disconnected source datastores. The sets are: [DWR_X_DEPTS] ; [DWR_X_EMP, DWR_X_LOC].
To design a Cartesian product, create a join and select Cross Join in its properties.
so here DWR_X_DEPTS is not having join with any other source.
so write a join condition.
Thanks for reply.
I want to add joins automatically as when we drag 2 data stores to interface canvas, and if they have referential integrity then join will automatically get added.
similar i am doing thru sdk, 2 data stores are get added but joinis not get added automatically, is ther any api call which sets all data store wit referential integrity,
other wise i need to find out foreign key by using code and need to add it to interface thru sdk.
you need to add it manually as of now i know for ODI.
in Quick Edit tab you have to choose your column to be joined.