Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please let me know how we can implement SCD (Slowly Changing Dimension) logic in QlikView?
■ Type 1: This methodology overwrites old with new data, and therefore does not track historical data. Its common uses are for misspelled names.
■ Type 2: This method tracks historical data by creating multiple records for a given natural key in the dimensional tables with separate surrogate keys and/or different version numbers. Unlimited history is preserved for each insert.
■ Type 3: This method tracks changes using separate columns and preserves limited history.
If possible can you please explain the same with sample data/Example?
Many thanks in advance…
See this blog post: Slowly Changing Dimensions
and the accompanying document: IntervalMatch and Slowly Changing Dimensions