Folks,
I am using ODI 11g.
I have a yellow interface ( YI-A) that has a two sources. One source is a physical oracle table (TAB-A) and the second source is another yellow interface (YI-B). I do have a join between the two sources. YI-B has only one physical table as a source..
The target data store for YI-A is YDS-A, and target data store for YI-B is YDS-B. In both yellow interfaces flow control = false and create_target_table=true.
When I execute Y1-A, it crashes on a step when it tries to insert records in YDS-A, it is doing a insert-select and selecting from YDS-B. Saying table does not exist. The problem is the YDS-B was never created or got any records inserted into it.
It does create YDS-A alright, but it never gets populated because the insert-select failed
So looks like a either a timing issue when I execute Y1-A, it needs to execute YI-B first, create and populate YDS-B, and then execute YI-A. Is there a way to control the order OR is it that we cannot use a yellow interface as a source in another yellow interface ? Is an issue with the knowledge modules being used perhaps ??
M. Jamal