How to remove Synthetic Key

[#1]

Hi,

Can someone tell me how to remove synthetic key for below scenario? I should not use link table, Table concatenate, Table Join.

[vivek_niti]

Hi,

Create a composite key instead..

Customer_ID&'|'&Store_ID AS link_Key,

Regards,

[#3]

Use Qualify , Disqualify

[#4]

HI,

   In the Weekly_Fact table and Monthly_Fact table use Autonumber(Locatio_ID , Store_ID)   and create the

composite key and give alias name as Key.

Remove Store_ID field from Weekly_Fact table  .

Remove Location_ID field from Monthly_Fact table  .

So there will be 2 fields in Weeky_Fact       "Key"   &  "Location_ID"  .

and there will be 2 fields in Monthly_Fact     "Key"   &  "Store_ID"  .

Location_Dimension table will be linked to Weekly_Fact table

Store_Dimension table will be linked to Monthly_Fact table.

Regards

Yusuf

[#5]

You can remove synthetic key by the following ways.

1.     using JOIN

2.     using CONCATENATE

3.     rename fieldnale

4.     using Qualify

[Anonymous]

I would also suggest to use Qualify and Unqualify

[Anonymous]

Concatenate  in fact tables.

and/or

drop field or rename fields with as