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 convert multiple rows to single row (multiple columns) in informatica
whats the logic to load the lower level of granularity of data to fact table.
What is the commit type if you have a transaction control transformation in the mapping?
What is InformaticaPowerCenter?
What is persistent lookup cache?
Write the unconnected lookup syntax?
How can we handle two sessions in informatica?
What are the types of caches in lookup? Explain them.
During the running session, output files are created by informatica server. Enlist few of them.
what are 3 tech challenges/ common issues you face?
What is session task and command task?
As union transformation gives UNION ALL output, how you will get the UNION output?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Is there any way to read the ms excel datas directly into informatica?
How can one identify whether mapping is correct or not without connecting session?