What is CDC? How to implement CDC?
- 4 Answers
- 21422 Views
- People Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is exclusive and normal mode for repository services?
What is deployment group?
How do you load first and last records into target table?
What is the difference between a connected look up and unconnected lookup?
What is Cognos script editor?
What is a snowflake schema?
What is meant by active and passive transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the shared cache and re-cache?
what is $$$$?
What is difference between a gateway node and worker node?
How to update a particular record in target with out running whole workflow?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
