Generate static values to junk dimension without having src

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Generate static values to junk dimension without having src

Post by satheesh_color »

Hi All,

The requirement is to generate static values to load the data into Junk dimesion and it is a one time data load.

Static Junk dimension table with all possible combinations for A(0/1/2) and B(0/1/2) Status Indicators (3*3=9 Records)

ColumnA ColumnB
0 0
0 1
0 2
1 0
1 1
1 2
2 0
2 1
2 2

I would like to generate the above records with out having any source data. Kindly let me know your thoughts on the same.


Regards,
S.R
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

This looks like a perfect example of where you would use the "Row generator" stage. I'd define Column A with a list of 9 values (0,0,01,1,1,2,2,2) and the Column B with a list of 3 values (0,1,2) and set the row generator to generate 9 rows.
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Post by satheesh_color »

Thanks ArndW.





Regards,
S.R
Post Reply