wht is cdc?how to use it in creation of mappings?
- 6 Answers
- 21690 Views
- HSBC, I also Faced
- E-Mail Answers
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
What is resilience time?
Differentiate between a repository server and a powerhouse?
Scheduling properties,whats the default (sequential)
What is the cumulative sum and moving sum?
What are the designer tools for creating transformations?
Enlist some properties of sessions.
What is informatica worklet?
Clarify the aggregator change?
What is option by which we can run all the sessions in a batch simultaneously?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How can you increase the performance in joiner transformation?
If informatica has its scheduler why using third party scheduler?
How to update a particular record in target with out running whole workflow?
What are the components of the workflow manager?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
