Fact tables to avoid loops and synthetic keys

[#1]

------------------------------------------------------------------------------------------------------------------

Like this Output I should Get please help me.

[alexandros17]

You could do ... (I give the idea, convert in correct syntax)

load * resident main

ledt join

load * resident product Group

and you could join the 2 table records

oad * resident record

join

load * resident record-1

what has happened now?

let me know

[its_anandrjs]

Hi,

Use composite keys here in your data model there are many fields are same in the tables and that is the reason you get many synthetic keys and the synthetic tables also in the data model. Do work on the remove the synthetic keys to rename them or create the composite keys from they and join them.

Load Description as Desc,* From Main;

Left Join

Load LocationID&_&ProductID as Key, ProductID as ProdID,* Record;

Regards

Anand

[#4]

Hi hello

My Actual DATA which is shown Above is like this .From this i want the output like this

Please help me this

Thanks in Advance