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
- 9173 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what is metadata?
Tell me one complex query in oracle ?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
How to eliminate duplicate records in informatica mapping? Explain with an example....
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
guys which is the best institute in banglore to learn informatica??
How do you use reject loader.
What is lookup transformation?
Write the unconnected lookup syntax and how to return more than one column.
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
what are the row and column separations in Flat Files
Teradata 
