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
- 9292 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
Can you generate sequence numbers without using the sequence generator transformation?
update strategy transformation in informatica
Target increases every day even though no new record was inserted
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is InformaticaPowerCenter?
What is Cognos script editor?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain the shared cache and re-cache?
What is a rank transform?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How might you approve all mappings in the archive all the while?
What is joiner transformation in informatica?
What is Data Caches size?
How can you generate reports in informatica?
