Data joins Help Needed

[Anonymous]

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