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.

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.

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---

Scheduling properties,whats the default (sequential)

0 Answers  

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

---

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---