INFORMATICA PUSH DOWN OPTIMIZATION (PDO)

PUSH DOWN OPTIMIZATION
=======================
CREATE MAPPING LIKE BELOW
--------------------------
 SRC(PARTY)->FILTER(PARTYINCOME>1000)-->SORT(PARTYLOC DESC FIRSTSORTCOL,PARTYCODE ASC
2NDSORTCOL,PARTYINCOME DESC 3RDSORTCOL)-->
 EXP(THREE PORTS ADDED
  CREATED BY: VINAY
  CREATED_DATE: SESSSTARTIME
  TOTAL_SAL=SAL * 12 )-->DEST

CREATE SESSION LIKE BELOW (WITHOUT PUSH DOWN OPTIMIZATION)
----------------------------------------------------------
CREATE SESSION WITH ADDITIONAL PROPERTIES
 WRITE BACKWORD COMPATIBLE SESSION LOG --TICK IT
 COLLECT PERFORMANCE DATA --CHECK IT
 (THIS WILL GIVE YOU COMPLETE TRANSFORMATION IN AND OUT RECORD COUNT)
 NOTE: DELETE SESSION LOGS BY GOING TO INFASHARED IN C:\Informatica\9.5.0\server
\infa_shared\SessLogs

RUN THE WORKFLOW WITHOUT PUSHDOWN FEATURE
------------------------------------------- RUN THE WORKFLOW AND SEE THE BELOW
 A) SESSION LOG->GET RUN PROPERTIES
 B) GOTO INFA_SHARED\SESSLOGS AND SEE THE SESSION LOG SELECT STATEMENT
 C) GOTO INFA_SHARED\SESSLOGS AND SEE THE PERFORMANCE COUNTER FILE
  AND OBSERVE EACH TRANSFORMATION INPUT AND OUT PUT COUNT OF ROWS

PREVIEW PUSH DOWN OPTIONS IMPLEMENTATION IN VIEWER
---------------------------------------------------
 SESSIONS->MAPPINGS->PUSH DOWN OPTIMIZATION
    TO SEE /VIEW (VIEWER)HOW MUCH SOURCE AND TARGET CAN GENERATE LOGIC AND PASSES

 TAKE OPTIONS ONE BY ONE AND PREVIEW THE FLOW

DESC:
=====
TO SOURCE-->HOW MUCH IT CAN PUSH TO SOURCE
TO TARGET-->TOWARDS TARGET HOW MUCH IS POSSIBLE
FULL->SELECTION,INSERTION ETC... EVERYTHING CONVERTED TO SQL.IT WILL NOT PASS ANYTHING TO
THE PIPELINE AND MOVES TO TARGET.
TO_SOURCE AND TO_TARGET HAVE LIMITATIONS,WHERE LESS LIMITATIONS ON FULL PDO
FULL POD USES DIFFERENT SOURCE CONNETIONS FOR ITS OPERATIONS.
FOR FULLPDO -->SOURCE AND TARGET SHOULD HAVE SAME RELATIONAL CONNECTION.(IF ERROR DO
THIS...)

PUSHDOWN IMPLEMENTATION
-----------------------
SPECIFY THE BELOW FEATURE IN THE PREVIOUS SESSION LEVEL.
SESSION->PROPERTIES TAB->PUSHDOWN OPTIMIZATION->TICK MARK AND CHOOSE OPTION FULL
RUN THE WORK FLOW AND OBSERVE THE BELOW

 A) SESSION STATISTICS ONLY ON PDO TABLE (NOT ON SOURCE AND TARGET)
 B) SEE THE QUERY IN PERFORMANCE LOG FILE (INSERT INTO SELECT STATEMENT).
 C) OBSERVE PERFORMANCE FILE AND SEE COUNTS (NO MORE COUNTS)