Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is an incremental loading? in which situations we will
use incremental loading

Answers were Sorted based on User's Feedback



What is an incremental loading? in which situations we will use incremental loading..

Answer / 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 ?    4 Yes 0 No

What is an incremental loading? in which situations we will use incremental loading..

Answer / jeevan kumar medapati

incremental loading means :: after completion of full load
we have to load new records only in to the tables this
process is called incremental load or delta load,
to perform incremental loading we are using LAST UPDATE
DATE>=ETL LAST RUN DATE method.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

How many dimensions are there in informatica?

0 Answers  


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,


why union is active transformation?

4 Answers   IBM,


What is union transformation?

0 Answers  


what is the difference between stop and abort?

3 Answers   TCS,






How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,


What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  


What is the use of code page?

0 Answers  


scenario

1 Answers  


In dimension and fact table? which one holds big data?

2 Answers  






Categories