IICS | Source Pushdown Optimization in Informatica Cloud

Hi Friends , Today we will learn how to implement Pushdown Optimization for the source and its introduction as well .

below are the DDL and dataset used for this video .

source :
CREATE TABLE "SRC"."CUST_PO_SRC"
( "EMP_ID" NUMBER(38,0),
"EMP_NM" VARCHAR2(100 BYTE),
"STATUS" VARCHAR2(50 BYTE),
"SRC_CD" VARCHAR2(50 BYTE),
"CITY" VARCHAR2(100 BYTE),
"COUNTRY" VARCHAR2(100 BYTE))

target :
CREATE TABLE "SRC"."CUST_PO_TGT"
( "EMP_ID" NUMBER(38,0),
"EMP_NM" VARCHAR2(100 BYTE),
"STATUS" VARCHAR2(50 BYTE),
"SRC_CD" VARCHAR2(50 BYTE),
"CITY" VARCHAR2(100 BYTE),
"COUNTRY" VARCHAR2(100 BYTE))

data :
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (10,'RAM','A','SAP','DELHI','INDIA');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (20,'STEVE','A','SAP','DALLAS','UNITED STATES');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (30,'ANGELA','A','SAP','MEXICO CITY','MEXICO');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (40,'RAVI','A','SAP','CANCUN','MEXICO');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (100,'PAT','A','SAP','CALGARY','CANADA');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (50,'DEV','A','SAP','CHENNAI','INDIA');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (70,'RAJ','A','SAP','PUNE','INDIA');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (80,'DIYA','A','SAP','INDORE','INDIA');
Insert into SRC.CUST_PO_SRC (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY) values (90,'RANI','A','SAP','BHOPAL','INDIA');