Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we handle change data capture in qlikview?
Thanks & Regards,
Kiran K.
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.
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.
That sounds like incremental loading. See this discussion for some links: Dynamic Update and Incremental Loading