Search found 1 match

by sjchanda
Sat Aug 11, 2012 11:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cartesian Join in PX
Replies: 6
Views: 2856

Cross join simplest option

To do a cross join with two files add a dummy column to both the files say "key" with a value of 1 for all rows. Then use join stage in inner join mode. For more than two files repeat the process with more such key columns and cascading inner joins.