what is incremental loading ?
Answer Posted / vijay
increamental loading is the concept of capturing the new
records and updated records from the source it is very help
full in scd's - 2
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What is informatica etl tool?
Enlist the tasks for which source qualifier transformation is used.
What are different types of transformations available in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Define pmcmd command?
What is a difference between complete, stop and abort?
What are the components of workflow manager?
Describe data concatenation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the different types of transformation available in informatica.
Clarify the aggregator change?
What is the surrogate key?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How can we use batches?