Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I am new to QlikView as a tool and I am working through a task I have been given. I have a Fact Table with transactional history and have been asked to create a Star Schema. How do I go about using the Fact Table to create the Reference Tables?
Regards
Martin
Hi Martin,
Does your fact table have a lot of repetition of data related to dimensions? For example if your fact table has CustomerID and a repeated Customer Name then you could make a simple customer dimensional table.
Customers:
Load
Distinct
CustomerID,
[Customer Name]
Resident Facts;
Drop Field [Customer Name] from Facts;
This will remove the repeating customer names from the fact table and you will have a Customers table holding the ID and the Name. Repeat for other dimensions enriching the dimensional tables with more fields where desirable.
Essentially we're doing a little bit of gentle normalisation of your single big fat fact table but in QlikView we don't need to push this process far.
Good luck
Andrew
Thank you,
I agree that a flat table would be better, but the task given to me wants to see a Star Schema.