Link tables

[#1]

Hi all ,

Can some one help me how to use link tables as i have two fact tables connecting to same dimmension tables, thus causing cirrcular loops and syntetic keys

Please find attachment

Thanks

[Jason_Michaelides]

Hi,

Concatenate() will often work better than a link table. Something like:

Data:

LOAD

  'type1' AS FactType,

  *

From....;

Concatenate (Data)

LOAD

  'type2' AS FactType,

  *

From....;

Hope this helps,

Jason

[#3]

Hi i cannot concatinate the fact tables as they deal with different measures one fact table is sales and the other fact table is orders

[Jason_Michaelides]

Which is why you use the FactType field. In your chart expressions you can use set analysis to distinguish between the different fact types - Sales and Orders.