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
- 9388 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is target designer and target load order?
Tell me about MD5 functions in informatica
Sequence generator, when you move from develoment to production how will you reset
waht type of interface is used for testing the data in informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is size of u r database?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Can anyone tell me the new features in Informatica 9 Version?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Reusable transformation and shortcut differences
Clarify the aggregator change?
What is a repository manager?
Write the prerequisite tasks to achieve the session partition?
