Interested to Buy Any Domain ? << Click Here >> for more details...
What is an incremental loading? in which situations we will
use incremental loading
- 2 Answers
- 9271 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sukanta
Incremental Loading is an approach.Let suppose you a mapping
for load the data from employee table to a employee_target
table on the hire date basis.Again let suppose you already
move the employee data from source to target up to the
employees hire date 31-12-2009.Your organization now want to
load data on employee_target today.Your target already have
the data of that employees having hire date up to
31-12-2009.so you now pickup the source data which are
hiring from 1-1-2010 to till date.That's why you needn't
take the data before than that date,if you do that wrongly
it is overhead for loading data again in target which is
already exists.So in source qualifier you filter the records
as per hire date and you can also parametrized the hire date
that help from which date you want to load data upon target.
This is the concept of Incremental loading.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do you update the records with or without using update strategy?
What are ETL Tools?
Explain lookup transformation is active in informatica
Briefly define a session task?
What are active transformations.
What is the reusable transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
To import the flat file definition into the designer where should the flat file be placed?
What is informatica metadata and where is it stored?
How do you load first and last records into target table?
How can we handle two sessions in informatica?
What is the procedure for creating independent data marts from informatica 7.1?
Explain the types of lookup transformation?
What is the fact table?
Explain the different dimensions.
