Hi Friends in this video , we will learn how to pass the value using in out parameter to 1 mapping task to another mapping task .
below are the table ddl we have used and flat file .
CUST_M1 DDL :
CREATE TABLE "TGT"."CUST_MT1"
( "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),
"CREATE_DATE" TIMESTAMP (6),
"UPDATE_DATE" TIMESTAMP (6),
"SALARY" NUMBER(16,2),
CONSTRAINT "CUST_EMP_ID_PK" PRIMARY KEY ("EMP_ID"))
CUST_MT2 DDL :
CREATE TABLE "TGT"."CUST_MT2"
( "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),
"SALARY" NUMBER(16,2),
"CREATE_DATE" TIMESTAMP (6),
"UPDATE_DATE" TIMESTAMP (6),
CONSTRAINT "CUST_MT2_EMP_ID_PK" PRIMARY KEY ("EMP_ID"))
Flat file data CUST.CSV
"EMP_ID","EMP_NM","STATUS","SRC_CD","CITY","COUNTRY","CREATE_DATE","UPDATE_DATE","SALARY"
10,"RAM","A","SAP","DELHI","INDIA","2023-05-01 06:10:36","2023-07-14 06:10:36","1000.15"
20,"STEVE","A","SAP","DALLAS","UNITED STATES","2023-05-01 09:15:20","2023-05-01 09:15:20","1235.35"
30,"ANGELA","A","SAP","MEXICO CITY","MEXICO","2023-06-02 10:12:45","2023-06-02 10:12:45","3763.65"
40,"RAVI","A","SAP","CANCUN","MEXICO","2023-06-02 11:23:35","2023-06-02 11:23:35","6000.76"
100,"PAT","A","SAP","CALGARY","CANADA","2023-07-13 13:24:34","2023-07-13 13:24:34","7030.62"
50,"DEV","A","SAP","CHENNAI","INDIA","2023-06-01 14:32:06","2023-06-01 14:32:06","8020.22"
70,"RAJ","A","SAP","PUNE","INDIA","2023-06-01 15:54:21","2023-06-01 15:54:21","5620.92"
80,"DIYA","A","SAP","INDORE","INDIA","2023-07-13 20:12:31","2023-07-13 20:12:31","3220.45"
90,"RANI","A","SAP","BHOPAL","INDIA","2023-07-12 23:47:41","2023-07-12 23:47:41","7620.26"
#informatica #iics #informática #tutorial #etltesting #datawarehouse #sql
