Interested to Buy Any Domain ? << Click Here >> for more details...
What is CDC? How to implement CDC?
- 4 Answers
- 23560 Views
- People Tech, TCS, I also Faced
- E-Mail Answers
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 |
how many data models u have done in informatica project?
explain different levels in pushdown optimization with example?
what is fact table?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
What is meant by a domain?
what is the difference between lookupoveride and joiner?
what are factless facts? And in which scenario will you use such kinds of fact tables.
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
what is plsql table?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is a parameter When and where do you them when does the value will be created
Teradata 
