22nd October 2018 | tech.ed training

Designing Fact Tables in Data Warehouses

The four steps to deriving a fact table when modelling a data warehouse are: Choosing business process to model – The first step is to decide what business process to model by gathering and understanding business needs and available dataDeclare the grain – by declaring a grain means describing exactly what a fact table record representsChoose the dimensions – once grain of...
Read More