Hi All,
I am having below data model from the source:
Dim 1(Account) | | Dim2 (Calendar) |
AccountID | | C Date |
Name | | Business Date |
Fact1 | Fact 2 |
AccountID | AccountID |
C Date | Business Date |
Dim1 account dimension which has 1 Milion accounts and it has account id and name columns.
Dim2 calendar dimension which is having 5 years data ie 2000 records has calendar date and business date .
Now Fact 1 is using acccount dimension's account id column and calendar dimension's c_Date column
and Fact 2 is having account id and business date columns.
But fact1's account id does not need to match Fact2.
I did cross join between DIM1 and DIM2 after that
I did left join with fact tables. It is working fine it has got huge record set is there any way I can reduce these counts?
Thanks
Dasu.G