What is CDC? How to implement CDC?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by term role-playing dimension?

596


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1702


What is the cumulative sum and moving sum?

770


What is flashback table ? Advance thanks

1497


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1984






How do you load alternate records into different tables through mapping flow?

1309


What is fact table? Explain the different kinds of facts.

621


can anyone suggest best free Talend data integration training online

1274


To import the flat file definition into the designer where should the flat file be placed?

683


Can we create a node as a gateway node and the same node can be assigned to a grid?

645


What is the way to execute pl/sql script using informatica mapping?

981


What are multi-group transformations?

573


What is status code in informatica?

594


Can u generate reports in Informatica?

663


How to create Target definition for flat files?

768