RELATING DATA FROM DIFFERENT SOURCES

[#1]

Hi,

I have 4 tables. One is FACT table other are DIM1 and DIM2. The last table is a fact table that is FACT2.

FACT1 contains data about call detail and contains field key1 key2 cal _year and cal_month

DIM1 contains data about employees and key1 and a column STATE

DIM2 contains data about plans and offers and key2  plan_year and plan_month

thus fact1 is related to dim1 using key1 and dim2 using key2

Now I want to bring in table FACT2 which contains data about sales. It has cycle_year and cycle_month and STATE and other facts.

Only year and month cannot be used to relate the FACT2 with existing model neither only STATE.

Please help me with this. How could I fit FACT2 in the data model without affecting the existing data.

[Jason_Michaelides]

When you load the first table, add a field:

'FACT1'     AS     FactType

Then concatenate the second fact table to the first, adding the field:

'FACT2'     AS     FactType

Hope this helps,

Jason