Scribd
Upload
8 views1 page

Pushdown Optimization in Informatica

The document discusses three types of pushdown optimization in Informatica: Source-side, Target-side, and Full Pushdown Optimization. Source-side optimization pushes transformation logic to the source database, while Target-side optimization does so to the target database, and Full Pushdown attempts to push all logic to the target, resorting to source-side if necessary. Instructions for enabling each type of optimization are provided within the context of a mapping task involving an Oracle EMPLOYEES table.

Uploaded by

iihtiics
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
8 views1 page

Pushdown Optimization in Informatica

The document discusses three types of pushdown optimization in Informatica: Source-side, Target-side, and Full Pushdown Optimization. Source-side optimization pushes transformation logic to the source database, while Target-side optimization does so to the target database, and Full Pushdown attempts to push all logic to the target, resorting to source-side if necessary. Instructions for enabling each type of optimization are provided within the context of a mapping task involving an Oracle EMPLOYEES table.

Uploaded by

iihtiics
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Source-side Pushdown Optimization

Target-side Pushdown Optimization


Full Pushdown Optimization
Source is an Oracle table EMPLOYEES table
Applying filter to read only details of employees with job_tile as Sales
Representative.
Next the data is sorted based on EMPLOYEE_ID before loading to target table.

When the mapping is triggered with no Pushdown optimization enabled, the entire
records from source table are read and then Informatica applies filter on top of
that data at Informatica level. Then the filtered data is sorted based on employee
id before loading into target.

In this method Informatica pushes as much transformation logic as possible to the


Source database. The Data Integration Service generates and executes a SELECT
statement based on the transformation logic for each transformation it can push to
the database.

To enable the Source side Pushdown Optimization, go to Schedule tab of the Mapping
task assigned to the mapping > Advanced Session Properties > click Add > from the
drop down select Pushdown Optimization as Session Property Name and To Source as
Session Property Value.

Target Side pushdown

In this method Informatica pushes as much transformation logic as possible to the


target database. The Data Integration Service generates an INSERT, DELETE, or
UPDATE statement based on the transformation logic for each transformation it can
push to the target database.

To enable the Target side Pushdown Optimization, select Pushdown Optimization as


Session Property Name and To Source as Session Property Value under Advanced
Session Properties.

The results are identical to the initial run with no Pushdown Optimization enabled.

Full Pushdown

In this method Informatica pushes as much transformation logic as possible to the


target database. If the entire logic cannot be pushed to target database, it
performs source-side pushdown and rest of the intermediate transformation logic
which cannot be pushed to any database is processed at Informatica level.

To enable the Target side Pushdown Optimization, select Pushdown Optimization as


Session Property Name and Full as Session Property Value under Advanced Session
Properties.

You might also like