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
- 9142 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
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can you differentiate between powercenter and power map?
How to use pmcmd utility command?
What are the new features of informatica 9.x at the developer level?
Explain pushdown optimization and types in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to create Target definition for flat files?
What do you mean by filter transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How many ways are there to create ports?
What is fact table? Explain the different kinds of facts.
How do you change a non-reusable transformation to reusable transformation?
How to extract sap data using informatica? What is abap? What are idocs?
What is standalone command task?
Did u used latest transformations of 8.6.0? for what?
