i have 3 facts tables which containing 60 million records and few dimension table ?what is the approach to develop data model? condition is u should not use concatenate between fact tables ? what is the other way ? pls explain me ?

[#1]

i have 3 facts tables which containing 60 million records and few dimension table ?what is the approach to develop data model? condition is u should not use concatenate between fact tables ? what is the other way ? pls explain me ?

[#2]

Perfect Your QlikView Data Model

Check out the above thread.

[marcus_malinow]

An alternative approach would be to use a LINK table

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table