wht is cdc?how to use it in creation of mappings?
Answer Posted / mike
capturing only changes is ok.. but in realtime as soon as the data changes in the source ... changes should be implmented in the target... so how's z dat done ? means hw we will know that source rows have been changed(suppose like evy 15 mins)? do we need to run the run mapping for evy 15mins? how does CDC works actually? i would really appreciate if some one can explain me?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
Write the unconnected lookup syntax and how to return more than one column.
What is the commit type if you have a transaction control transformation in the mapping?
What is fact table? Explain the different kinds of facts.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
draw informatica architecture 8.6 ?
Is it possible to revert a global repository to local one and why?
What are the measure objects?
What is target designer and target load order?
If informatica has its scheduler why using third party scheduler?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the advantages of using informatica as an etl tool over teradata?
What do you mean by enterprise data warehousing?
What is persistent lookup cache?