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


Please Help Members By Posting Answers For Below Questions

What is target designer and target load order?

652


What are the components of workflow manager?

584


What are multi-group transformations?

556


how to load rows into fact table in data warehouse

634


What are the differences between a connected lookup and unconnected lookup?

641






How can informatica be used for an organization?

647


What is option by which we can run all the sessions in a batch simultaneously?

659


draw informatica architecture 8.6 ?

3468


What is Data Caches size?

652


Explain the different lookup methods used in informatica?

581


How an expression transformation differs from aggregator transformation?

622


Mention a few design and development best practices for informatica?

555


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1525


What are the different transaction levels available in transaction control transformation?

671


Name the different lookup cache(s)?

699