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.
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 |
What is the difference between IN and Exists in Oracle?
State the limitations where we cannot use joiner in the mapping pipeline?
hi all, Can anyone please tell me the relationship between informatica and business objects
Why update strategy and union transformations are active? Explain with examples.
Performance tuning( what you did in performance tuning)
How can you define a transformation? What are different types of transformations in Informatica?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
What is difference between a gateway node and worker node?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Kimball and Inmon methodologies?
What are the types of data warehouses?