Data joins Help Needed

Anonymous — Mon, 29 Apr 2013 19:50:38 GMT

Hi All,

I am having below data model from the source:

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

topic Data joins Help Needed in QlikView