Discussion Board for collaboration related to QlikView App Development.
How can we handle change data capture in qlikview?
Thanks & Regards,
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.
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
That sounds like incremental loading. See this discussion for some links: Dynamic Update and Incremental Loading