Cartesian Join - A Quick DataStage Recipe

What to Cook:
How to do Cartesian join -> Join every row of a table to every row of other table

Use "column generator" stage

How to Cook:
Add both tables in DS job
Add dummy column using "Column Generator" stage each for both tables. Make sure dummy column values are same.
Join both tables using these  dummy columns

Like the below page to get update!forum/datagenx

No comments

Powered by Blogger.