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.

what is parameter file?

1 Answers   Cap Gemini,

---

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

---

what is distinct

4 Answers  

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  

---

What are the types of error logs available in Informatica?

1 Answers  

---

What is a test load?

1 Answers  

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

What is domain in terms of informatica?

0 Answers  

---