In what scenario we use to improve session performance by pushdown optimization?can any one give example?

Answer Posted / jaspreet banga

One can push transformation logic to the source or target
database using pushdown optimization. The Integration
Service translates the transformation logic into SQL
queries and sends the SQL queries to the source or the
target database which executes the SQL queries to process
the transformations. The amount of transformation logic one
can push to the database depends on the database,
transformation logic, and mapping and session
configuration. The Integration Service analyzes the
transformation logic it can push to the database and
executes the SQL statement generated against the source or
target tables, and it processes any transformation logic
that it cannot push to the database.

just consider the example:----

Suppose a mapping contains a Filter transformation that
filters out all employees except those with a DEPTNO
greater than 40. The Integration Service can push the
transformation logic to the database. It generates the
following SQL statement to process the transformation logic:

INSERT INTO EMP_TGT(EMPNO, ENAME, SAL, COMM, DEPTNO)
SELECT
EMP_SRC.EMPNO,
EMP_SRC.ENAME,
EMP_SRC.SAL,
EMP_SRC.COMM,
EMP_SRC.DEPTNO
FROM EMP_SRC
WHERE (EMP_SRC.DEPTNO >40)
The Integration Service generates an INSERT SELECT
statement and it filters the data using a WHERE clause. The
Integration Service does not extract data from the database
at this time

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you migrate data from one environment to another?

858


What is an expression transformation?

808


What is an unconnected transformation?

861


What is the difference between writing a joiner query in ANSI style and THETA style?

2139


Difference between Data and Index Caches?

870


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10445


What is a predefined event?

851


What is the Rank index port in Rank transformation?

851


Explain load alternative records / rows into multiple targets - informatica

902


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9368


What is meant by LDAP users?

876


What are the types of caches in lookup? Explain them.

752


Mention a few design and development best practices for informatica?

749


how to load rows into fact table in data warehouse

894


Where are the source flat files kept before running the session?

846