2 fact tables

[#1]

I have two fact tables, which are linked based on ID. In  fact table1,  I have 100 ID's and in Fact Table2, I have 50 ID's. I am linking Territory to Fact Table2. Now the problem is I have to show all 100 ID's at Territory level but I just have 50ID's in the Fact Table2 where Terr is linked.

Thanks

[chiru_thota]

Hi Pramod,

I guess your scenario seems as shown in the below screenshot.

(1) Soultion 1:   Join both Fact1 and Fact2 on ID.

So that you will  have single table and all the records will have Teritory_ID to connect to Dim_Terr table

(2) Solution2:   Get Teritory_ID into Fact1 from Fact2 by joining on column ID.

So that Fact1 table will have Territory_ID to connect to Dim_Terr.

[#3]

Thankyou, I can't join any table in the data model. The data model is already complex.

[chiru_thota]

Ok.

I guess you can take all the ID's in Fact1 table and concatenate to table Fact2.

Ex: 

Load * from Fact2;

concatenate

Load ID resident  Fact1;