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.
- 1 Answers
- 6584 Views
- I also Faced
- E-Mail Answers
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
To import the flat file definition into the designer where should the flat file be placed?
What is an unconnected transformation?
How do you update the records with or without using update strategy?
Write the program through which the records can be updated?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Where are the source flat files kept before running the session?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain how many types of dimensions are available in informatica?
How would you copy the content of one repository to another repository?
What is a shortcut and copy in Informatica and how two are different with each other?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the types of data warehouses?
How does a rank transform differ from aggregator transform functions max and min?
explain one complex mapping with logic? sales project?
complex mapping ur project u r invlve can u explain and give real time example give me ?
