Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Data model that is growing every sprint.
Now, I have 2 fact tables that have ALias names as Key Fields for the Link Table that I created.
Again, when I have added one more fact table it is creating a synthetic key, for this I have again trying to create a new Link Table.
So, can i rename the key field that I created first and used this in a brand new key field for the second Link Table.
Thanks in advance for your help.
For example scenario:
FactTable1:
Load Field1 &'|'& Field2 as LinkTable1_key,
Field2 &'|'& Field2 as LinkTable2_Key,
..
..
From FactTableA;
FactTable2:
Load Field1 &'|'& Field2 as LinkTable1_key
..
..
From FactTableB;
Now can I use the first fact table and do the below so that I can create a new key field?
FactTable1:
Load LinkTable1_key &'|'& LinkTable2_Key as LinkTable3_Key,
..
..
From FactTable1;
Regards,
Shyam.
Hi,
Attach some sample data and explain your requirement.
Regards,
Jagan.