DSXchange

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

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.

Thanks ArndW.





Regards,
S.R