What is an incremental loading? in which situations we will
use incremental loading
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 workflow? What are the components of workflow manager?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Different sorts of metadata that stores in the storage facility?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Define joiner transformation?
What are the different types of repositories created using informatica?
What is fact table? Explain the different kinds of facts.
How can we update a record in the target table without using update strategy?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Write the program through which the records can be updated?
What is the difference between informatica 7.0 and 8.0?
How to Create a folder using pmrep command?
How many transformations can be used in mapplets.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are mapplets?