Cartesian product

[Anonymous]

Hi, how can I do to obtain a cartesian product between two oracle tables?I use tMap component. Thank you.

[Anonymous]

Ok, I see your problem.
The solution I propose is not the better solution because a bug prevents to connect correctly a third RunBefore from tOracleInput to tELTOracleMap. Even it is possible, it implies a compilation error. I created a bug report on this subject 1077.
So an alternative solution should be to use a tRunJob to start ELT processing like in the image.

Now, I can't use this solution because in the stap1 my job don't terminate with 2 tOracleOutput, but 1 tAggregateRow and 1 tMap (a)!!!!!
Amaumont do you have any solution?

[amaumont]

Can you post a snapshot of your job ?