Hi All, i have question regarding Change Data Capture in
Informatica. As i know we can do this using Incremental
Aggregation(i never worked on Informatica but i read) and i
think we can do the same with SQL Over write and with
variables. Can someone tell me how do we do this using
other two techniques.. using SQL Over write and variables.
Thanks for the help and greatly appreciated.
Answer Posted / rajesh_audhi
If u have audit columns in the source like load_date we can
easily captured the changed data.we will extract only
changed data thru a query override in source qualifier by
giving like load_date>$$load_date.$$load_date is a mapping
variable which we set this value to the max(load_date)
during run time of session.so that it will store
max(load_date) in the variable and next time when we run the
same mapping it will fetch the source rows based on the
condition load_date>$$load_date.we will set this $$load_date
to max value using setmaxvalue function in any expression
transformation.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Could you explain what is enterprise data warehouse?
How to create Target definition for flat files?
Write the advantages of partitioning a session?
How many number of sessions can one group in batches?
What is sorter transformation?
How might you approve all mappings in the archive all the while?
what is the size of your data warehousing?
How do you load only null records into target?
How to differentiate between the active and passive transformations?
What is substr in informatica?
What is a repository manager?
What is rank index in rank transformation?
can u give example for factless fact table
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What's the layout of parameter file (what does a parameter file contain?)?