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 |
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Define mapplet?
what is constraint based load order
Tell me about MD5 functions in informatica
How can you define a transformation? What are different types of transformations in Informatica?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What is a rank transform?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
how can u load the data in time dimension?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
How can u work with remote database in informatica?did you work directly by using remote connections?