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…
