top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is incremental loading in Informatica?

+1 vote
What is incremental loading in Informatica?
posted Jun 1, 2015 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Incremental load is adding/inserting only changed/latest data from the source.In incremental loading,history data could remain as it is along with the new data or overwritten by incremental data.

When use Incremental loading:

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 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 parameterized the hire date that help from which date you want to load data upon target.

answer Jun 2, 2015 by Manikandan J
Similar Questions
+2 votes

I am performing SCD type 1 mapping. I have these source tables.

1.CUSTOMERS, (Source customer File)
2.PRODUCTS (Source Product File)
3.SALES   (source Sales file)

Also, these are dimensions and fact tables.

2.D_PRODUCTS (SCD 1) and
3.F_SALES_DLY (Fact)

Sales contains daily level data. Fact table will have sales & quantity data aggregated for product & for a month.(Fact table should be incremental for 24 months.(It should always contain 24 months of data)

I am bit confused, How to make fact table incremental? If i try to use any transformation(filter) to get last 24 months records, is it feasible solution?

Please suggest me something..


+1 vote

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

+2 votes

I'm trying to load within an Oracle XE 10g database. When I run an Informatica PowerCenter Workflow, I get a following error:

CMN_1022    Database driver error...
CMN_1022 [Database driver event...Error occurred loading library [pmora8.dll]. System error encountered is 193. Error text is %1 is not a valid Win32 application.

Any ideas what might be causing this error? My environment is as follows:
•Windows Server 2008 R2
•Informatica PowerCenter 9.5
•Oracle XE 10 G

Powercenter repository is on SQL Server 2012.

+2 votes

Can you please help me to find out solution for the below error message.

UTY4014 Access module error '34' received during 'set position' operation: 'pmUnxDskSetPos: fseek error (System error message detected: 29)'

Overview of the mapping: My Source is Oracle and Teradata, I am joining both the tables in my mapping and loading it into the teradata table.

Any suggestion?