Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6968 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
Explain how many types of dimensions are available in informatica?
What is a surrogate key?
What is informatica worklet?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Mention a few design and development best practices for informatica?
What are the components of the workflow manager?
What is enterprise data warehousing?
Explain the difference between mapping parameter and mapping variable?
what is INFORMATICA TESTING process
What is a sorter transformation?
How can you differentiate between powercenter and power map?
What is a mapplet/worklet in informatica?
What is Index Caches size?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What all join we can perform in LOOKUP transformation?
