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
What do you understand by SOA of Informatica?
Is it possible to revert a global repository to local one and why?
Suppose we do not group by on any ports of the aggregator what will be the output?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is substr in informatica?
What is the different lookup cache(s)?
What is a rank transform?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is aggregator transformation in informatica?
Briefly define reusable transformation?
How to delete duplicate row using informatica?
Is stop and abort are same in informatica?
How to load a Dimension ? and how to load a fact table?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is sorter transformation?