Search found 1 match
- 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.