Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

deepaktibhe
Valued Contributor

Data model.

Hello All,

Please find attached screenshot.

My FK are in two tables CAl and organisation.

Can you please suggest what shall I do for making star schema for this.

thanks,

Deepak

4 Replies
Partner
Partner

Re: Data model.

concatenate the two tables into one

I can walk on water when it freezes
Not applicable

Re: Data model.

you have more than one fact tables do there are two way two reduce tables...

1. Concatenating the to fact tables

2. use link table

Regards

vinay

Re: Data model.

Use the link tables for linking two facts otherwise once stage before concate this facts or may be create the single table from both the two tables.

Partner
Partner

Re: Data model.

See the attached

good luck

Fernando