What is CDC? How to implement CDC?
Answer Posted / abhinaw prakash
CDC is changed data capture.
We can implement the same in Informatica using a filter transformation and passing only the Incremental rows.
A better option in this would be to dynamically create a parameter file every time the workflow runs and using the its value in the filter expression.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to generate or load values in to the target table based on a column value using informatica etl tool.
write a query to retrieve the latest records from the table sorted by version(scd)
What do you mean by blocking transformation?
What is aggregate cache in aggregator transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Why filter transformation is an active one?
What is meant by query override?
Can we get 1st record through Informatica(without sequence number).
How to do unit testing in informatica? How to load data in informatica ?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What do you mean incremental aggregation?
tell me the rules and responsblites in our project(my project is development)
How can we improve session performance in aggregator transformation?
How do you handle two sessions in Informatica
What is the command used to run a batch?