Interested to Buy Any Domain ? << Click Here >> for more details...
wht is cdc?how to use it in creation of mappings?
- 6 Answers
- 22921 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
Describe an informatica powercenter?
what is mean by complex business rule ?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the performance considerations when working with aggregator transformation?
How to update source definition?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the command used to run a batch?
What is difference between a gateway node and worker node?
What is a stored procedure transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are mapplets? How is it different from a Reusable Transformation?
How can we use mapping variables in informatica? Where do we use them?
How can you generate reports in informatica?
What is the need for an etl tool?
Enlist the tasks for which source qualifier transformation is used.
