When planning a data warehouse, developers are often faced with the requirement to maintain a history of changes.
To meet the requirements, they choose one of eight slowly changing dimensions types.
The type of slowly changing dimensions that suits the most business requirements is determined by the needs of business users and the amount of data they will store.
As part of the thesis, we will create a solution that will use one of the types of slowly changing dimensions.
The main part of the solution, which will solve the problem of preserving history, will be developed in the Exasol system with the help of scripts written in the Lua programming language.
We used the slowly changing dimensions type 7 in the solution, thus fulfilling the requirement to keep a history of changes.
Using this type, we can directly access the data that was valid at the time of entering the record or the data that is valid now from the fact table.
|
