Modeling Multiple Facts and Dimensions

[#1]

Hello,

I loaded my data into Qlikview and got the following table view.

The AWBs and the AWBsHistory tables are Facts and the rest are dimensions.

I had synthetic keys  and solved them by renaming the columns that caused them.

Is it ok for the fact table to have more than one relation? or should I use the Link table as the granularity and columns aren't the same in the 2 facts I have?

Appreciate your comments and input

[gautik92]

Join PIMapping and AWB's History

[Michiel_QV_Fan]

Each datamodel has it's specific needs. To enhance your knowledge I recommend to read a book from Kimball.