RELATING DATA FROM DIFFERENT SOURCES

Fri, 25 Oct 2013 13:14:48 GMT

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.

Re: RELATING DATA FROM DIFFERENT SOURCES

Jason_Michaelides — Fri, 25 Oct 2013 13:18:13 GMT

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