Cartesian Products in 2 flat files
Asked By
60 points
N/A
Posted on - 04/14/2012
Hello Dear,
If you want to join 2 flat files or tables by using the Cartesian product so you should set condition 1 = 1 in join and then just take the expression after two sources qualifier and define a numeric output port with that value which is equal to 1 in the both expressions and then use this column as join condition.
Hope my solution will be helpful for you.