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
Separate from an archive server and a powerhouse?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How might one distinguish in the case of mapping is right or not without associating session?
What does role playing dimension mean?
Explain the pipeline partition with real time example?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is workflow manager?
What is complex mapping?
How many transformations can be used in mapplets.
How to generate sequence numbers?
What is DR strategy for Informatica project?
design of staging area?
What is a joiner transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What can we do to improve the performance of informatica aggregator transformation?