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
- 6894 Views
- I also Faced
- E-Mail Answers
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 |
how we do performence tuning in informatica
What is difference between Mapplet and reusable transformation?
When will you use SQL override in a lookup transformation?
What are events in workflow manager?
What is a design?
explain about informatica server architecture?
During the running session, output files are created by informatica server. Enlist few of them.
How can you define a transformation? What are different types of transformations in Informatica?
Define Incremental Aggregation?
Explain what is informatica metadata and where is it stored?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
Teradata 
