syntheic key issue

[#1]

can any one help me to genrate script for link table to resolve the issue in the attatched file.

i have two dimension partno and stockist and two fact purchase and recipt.

how to genrate the script for link table while my dimension and fact is loading from qvd how to tackel residence command.

[CELAMBARASAN]

Hi,

     I cann't open your file because of personal edition user.

     I assume that your problem is synthetic key.

     To eliminate synthetic key Join the 2 fields and make that as key bet 2 tables.

     Then use qualify for that 2 fields.

     For example

     qualify product,billno;

     Table1:

     Load

          product & billno as Key,

          product,

          billno

     From..

     Table2:

     Load

          product & billno as Key,

          product,

          billno

     From..

Celambarasan

[jagan]

Hi,

Just paste the script or attach the screenshot of the mapping diagram, it helps in understanding the problem.

Regards,

Jagan.

[#4 · Accepted solution]

See the attached file. You have to reload it first. Think it should work like this.

Best regards,

William

[#5]

absulutly perfect William..

thnks alot.

[#6]

wht if i have

three same column but one filed is differnet say:

1st cube:

employee_id

location

item

supplier_id

purchase_Cost

2nd cube:

employee_id

location

item

customer_id

sold_Cost

how to manage this.............

[CELAMBARASAN]

If my understanding is correct then both the tables meaning is different

1st is about purchase

2nd is about sold then u can ve it has separate

1st cube:

employee_id

location AS PurchaseLoc

item AS PurchaseItm

supplier_id

purchase_Cost

2nd cube:

employee_id

location AS SaleLoc

item AS SaleItm

customer_id

sold_Cost

If i'm wrong let me know

Celambarasan