what is incremental loading ?
Answer Posted / gopinath
In Incremental loading the differnce between the source and
target are dumped at regular intervals. Here we give the
last extract date so that changes only of this particular
date will be loaded to the target tables.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
how many types of dimensions are available in informatica?
What is mapping debugger?
What is the session task and command task?
What is an expression transformation in informatica?
What do you understand by SOA of Informatica?
How to call shell scripts from informatica?
How to update a particular record in target with out running whole workflow?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the function of union transformation?
According to his methodology what all you need before you build a datawarehouse
How do you load first and last records into target table?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to generate sequence numbers without using the sequence generator transformation?
What is informatica?