In an ODI interface, can source tables be declared as not joined?
A.
Yes, ODI generates the code calculating a sample of the data, profiling it, and deciding
automatically if a join exists.
B.
Yes, it is possible to create an ODI procedure to declare joins for the source tables.
C.
No, in ODI, it is mandatory that all the source data stores are joined directly or indirectly.
D.
No, by default, every added data store in the source declaration of an interface is joined with an
inner join.
Explanation:
I agree C is correct.
When you drag and drop a data store to the interface there is no sql join added. You have to join it manually, but if there’re a referencial constraints, like in XML for example, the wizard build it automatically ! so is C!
C is correct