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 |
expain about the tune parameters?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
how can we load starting with 11th record of a table from source to target
Different sorts of metadata that stores in the storage facility?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
Major difference between SQL override and Lookup Sql override
Tell me about Propagate functions in informatica
what are the output files that the informatica server creats during running a session?
What is facttable granularity?
How many input parameters can exist in an unconnected lookup?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
wat s mapping parameter and mapping variable? how do you set that in a mapping?