wht is cdc?how to use it in creation of mappings?
Answer Posted / sreekanth
CDC stands for change data capture
Daily several transaction may happen among those some may
adds new records to the OLTP and some transaction updates
the existing so we need to capture the changes then while
loading the data we need to update on the existing date ware
house with changes made to OLTP for this we will maintains
when created and when updated audit column in OLTP according
those fields we can load the data to targt.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
How to elaborate tracing level?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Which are the different editions of informatica powercenter that are available?
What are the issues you have faced in your project? How did you overcome those issues?
Differences between connected and unconnected lookup?
What is the difference between router and filter?
How can we delete duplicate rows from flat files?
what is the hint? how to use it to reduce the query processing in program?
What is an Integration service in Informatica?
What is the use of target designer?
Explain the types of lookup transformation?
How do you load only null records into target? Explain through mapping flow.
How can you differentiate between powercenter and power map?
can we override a native sql query within informatica? Where do we do it?