Generate static values to junk dimension without having src
Posted: Thu Jun 07, 2018 12:42 am
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
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