I am building an account dimension in two steps with two interfaces.
When I insert via the second interface, some of the rows are in the accounts interface table are inserted before the primary member, causing an error on the dimension build.
Is there a setting or a way from within ODI to force the second interface resultset to be inserted after the first?
Do you execute the interfaces in a package? If so, you can execute them synchronously, allowing the first to finish prior to the second beginning. If not, how are you currently running them?