Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Join PIMapping and AWB's History
Each datamodel has it's specific needs. To enhance your knowledge I recommend to read a book from Kimball.