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

Enlist the various types of transformations.

723


How to join three sources using joiner?

778


What is rank transform?

742


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6910


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1662


Under which circumstances, informatica server creates reject files?

810


What are the differences between joiner transformation and source qualifier transformation?

854


what are factless facts? And in which scenario will you use such kinds of fact tables.

1509


What is the difference between informatics 7x and 8x and what is latest version?

778


What is a surrogate key?

792


What is the maplet?

791


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1324


What are some examples of informatica etl programs?

716


Explain the difference between a data warehouse and a data mart?

786


Explain the use of aggregator cache file?

905