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

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1552


While importing the relational source definition from the database, what are the metadata of source that will be imported?

786


What could be the possible resons of locks by user?

659


How can you define user defied event?

616


How can we create index after completion of load process?

596






How can we use mapping variables in informatica? Where do we use them?

616


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2276


Make a note of the quantity vaults made in informatica?

553


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1749


Global and Local shortcuts. Advantages.

1466


How do you change a non-reusable transformation to reusable transformation?

596


Whats there in global repository

1264


Please let me know how to make Data masking in informatica..

1267


Which transformation is needed while using the Cobol sources as source definitions?

727


Which version configuration tool used in ur project?

2762