generate distinct combinations for a given set of data
Posted: Tue Jul 24, 2012 9:31 am
Hello,
I need to create a bridge table with all possible combinations for a clms and want to know if it can be done through DS 8.7 version -
Eg -
Dimension table
------------------
Code_clm
1
2
3
Bridge table
--------------
bridge_key.....Code_clm
0001 .......... 1
0002 .......... 2
0003 .......... 3
0004 .......... 1
0004 .......... 2
0005 .......... 1
0005 .......... 3
0006 .......... 2
0006 .......... 3
0007 .......... 1
0007 .......... 2
0007 .......... 3
Note : the "......" are just for formating.
Please help if you know of a way to achieve this in DataStage 8.7.
Thanks,
nsg
I need to create a bridge table with all possible combinations for a clms and want to know if it can be done through DS 8.7 version -
Eg -
Dimension table
------------------
Code_clm
1
2
3
Bridge table
--------------
bridge_key.....Code_clm
0001 .......... 1
0002 .......... 2
0003 .......... 3
0004 .......... 1
0004 .......... 2
0005 .......... 1
0005 .......... 3
0006 .......... 2
0006 .......... 3
0007 .......... 1
0007 .......... 2
0007 .......... 3
Note : the "......" are just for formating.
Please help if you know of a way to achieve this in DataStage 8.7.
Thanks,
nsg