What is an incremental loading? in which situations we will
use incremental loading
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 |
can any one give some examples for pre sql and post sql(Except dropping and creating index).
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
What is the advantage of informatica?
Can anyone tell me the new features in Informatica 9 Version?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?