Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change data capture

How can we handle change data capture in qlikview?

Thanks & Regards,

Kiran K.

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

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.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand