Renaming the Alias named Field for LinkTable use

shyamcharan — Mon, 22 Sep 2014 02:33:16 GMT

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.

Re: Renaming the Alias named Field for LinkTable use

jagan — Mon, 22 Sep 2014 03:59:52 GMT

Hi,

Attach some sample data and explain your requirement.

Regards,

Jagan.