Slowly Changing Dimension logic in QlikView

Mon, 15 Jul 2013 13:31:29 GMT

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…

Re: Slowly Changing Dimension logic in QlikView

Gysbert_Wassenaar — Mon, 15 Jul 2013 13:32:55 GMT

See this blog post: Slowly Changing Dimensions

and the accompanying document: IntervalMatch and Slowly Changing Dimensions

topic Re: Slowly Changing Dimension logic in QlikView in QlikView

Slowly Changing Dimension logic in QlikView

Re: Slowly Changing Dimension logic in QlikView