topic Change data capture in QlikView

Change data capture

Anonymous — Fri, 04 Jul 2014 07:24:55 GMT

How can we handle change data capture in qlikview?

Thanks & Regards,

Kiran K.

Re: Change data capture

Gysbert_Wassenaar — Fri, 04 Jul 2014 09:20:13 GMT

That's a very generic question. But in generally the same way as in other systems, i.e. using timestamps or version numbers. If you mean dealing with slowly changing dimensions then have a look at this blog post: Slowly Changing Dimensions.

Re: Change data capture

Anonymous — Fri, 04 Jul 2014 12:52:15 GMT

Dear Gysbert,

Thanks for reply.

I know about about SCD things.

CDC is more about capturing only updated record from source system.

ETL tool like informetica,ODI have special program to capture such changes and write it into separate table

This new table contain only modified records.

Can same thing we can achive using qlikview?

Thanks & Regards

Kiran K.

Re: Change data capture

Gysbert_Wassenaar — Fri, 04 Jul 2014 12:55:58 GMT

That sounds like incremental loading. See this discussion for some links: Dynamic Update and Incremental Loading