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
