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 is partioning?how many types of partinings are there
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
daily how much amount of data send to production?
Scheduling properties,whats the default (sequential)
why we use datawarehouse
What are the active and passive transforamtions?
How to jion 2 tables, without using any condition?
What is the filename which you need to configure in UNIX while installing infromatica?
How can you join two tables without any common column present in them?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
Can I create one wrkflw which will run different wrkflws on schedule time?
What is the function of aggregator transformation?