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
- 9274 Views
- HCL, I also Faced
- E-Mail Answers
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 |
what is inline view?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
In a sequential batch can you run the session if previous session fails?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is fact table?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Explain what is informatica metadata and where is it stored?
In which scenario did you used pushdown optimization?
How to load only the first and last record of a flat file into the target?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Teradata 
