topic Re: SCD in QlikView

SCD

prabhas277 — Tue, 02 Jun 2015 05:17:22 GMT

Hi Experts,

What is scd? Interval match and scd are same in qlikview? if not same then how we can explain scd in interview point of view?

Regards,

prabhas

Re: SCD

Tue, 02 Jun 2015 05:53:19 GMT

Hi,

You can refer the link below.

https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions

Re: SCD

hic — Tue, 02 Jun 2015 06:03:07 GMT

"Slowly changing dimensions" is a data model challenge that you may encounter when you model your business processes.

Intervalmatch is a tool in QlikView/Qlik Sense. You can use the Extended Intervalmatch to model the SCD.

HIC

Re: SCD

vardhancse — Tue, 02 Jun 2015 06:05:18 GMT

Hi,

For some reporting purpose we need historical data for some fields in the table, in order to maintain that we will create some additional tables in our script using resident loads.

so that for every split we will get the record entered so that at any point of time we can get the historical data.

for eg: say emp status/promotion

Re: SCD

jagan — Tue, 02 Jun 2015 06:54:42 GMT

Hi,

check this link hope it helps you.

datawarehouse4u.info/SCD-Slowly-Changing-Dimensions.html

SCD - Slowly changing dimension, for example the price of a product will change over a period of time to know the price of the product on a particular data SCD types are used, this can handled in different techniques, refer above link for details.

The same we can achieve this using the IntervalMatch() in qlikview.

Regards,

jagan.