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
Generate static values to junk dimension without having src
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am