Create SatrSchema from one Fact Table

[Anonymous]

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

[effinty2112]

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

[Anonymous]

Thank you,

I agree that a flat table would be better, but the task given to me wants to see a Star Schema.