wht is cdc?how to use it in creation of mappings?
Answer Posted / vaibhav bhandeo
CDC stands for change data capture. This is used to
implement incremental load approach in data warehouse.
In this approach we traditionally keep a date field and
pull data on incremental date values.
This assures that we are picking latest data (Or may be new
batch data which ever is applicable).
Implementing this in mapping would require you to use
parameter files which will keep HiWaterMark and LoWatermark
which is repeatedly used to capture fresh data.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
Describe expression transformation?
Explain the features of connected and unconnected lookup.
Tell me about MD5 functions in informatica
How is union transformation utilized?
What are the limitations of joiner transformation?
Mention a few design and development best practices for informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are Dimensional table?
What is rank index in rank transformation?
Could you explain what is enterprise data warehouse?
What is target designer and target load order?
Differences between version 7.x and 8.x.
What is the function of look up transformation?
What is substr in informatica?