I am adding data stores in Interface using odi sdk, it gives me warning "All data stores in a dataset should be joined......" and flow is also not created; giving FATAL/critical error message.
If I manually drag the data stores in interface, it automatically add join, as one of the table have foreign key as referential integrity, not giving any warning/error
but through code join is not get added automatically.
anyone please give me code snippet which add referential integrity(foreign key) as a join automatically
Thanks in advance,
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.