on 07-24-2018 8:39 AM
I WANT TO CREATE A JOB IN BODS TO ADD -1 DUMMY KEY TO EACH DIMENSION(LOAD_DUMMY_DIM_KEYS)? PLEASE SUGGEST
Hi Arunabh.
You can use the row generator transform in every dataflow where you are loading dimensions. In row generator create the column and load with pre-defined values. Merge this and the actual data for dimensions and load the target.
PS: Always best not to use Caps on when writing on public forums.
Regards. S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.