What is CDC? How to implement CDC?
Answers were Sorted based on User's Feedback
Answer / bharu_295
hi cdc stands for capture data change.
it is done by using incremental loading of the source data.
ex: in source take a column modified date
in mapping take sysdate as one column and get data with modifieddate>sysdate. condition.
| Is This Answer Correct ? | 11 Yes | 7 No |
Answer / reddy
CDC Stands for Change Data Capture. All Changed
transactions will be moved from Source system to
destination through Archive Logs.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
What are the measure objects?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
What are the performance considerations when working with aggregator transformation?
Whatis the difference between View and Materialized View ?
How do you join more than 3 flat files in informatica?
Differentiate between sessions and batches?
What do mean by local and global repository?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you remove duplicate records in informatica?
How to read data from flat file source if the data is in paragraph format?
Differences between connected and unconnected lookup?