Скачать с ютуб IICS | Transaction control Transformation in Informatica Cloud |How To Create Dynamic Files в хорошем качестве

IICS | Transaction control Transformation in Informatica Cloud |How To Create Dynamic Files

Hi Friends in this video we will learn how we can create file based on one of source coulumn value , for example in my source data i have 3 countries india , usa and mexico , so we will use transaction control transformation and we will split the data and create file for each country with its data inside . Please check out below videos on how to create Mapping Task :    • IICS | Create First Mapping Task in I...   Please check out below videos on how to create Taskflow :    • IICS | Create  First TASKFLOW in Info...   below are dll and insert and data used , please change schema and database names as per your database : Oracle table ddl CREATE TABLE "SRC"."CUST" ( "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), "UPDATE_DT" DATE ) oracle Insert : Insert into SRC.CUST (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY,UPDATE_DT) values (10,'RAM','A','SAP','DELHI','INDIA',to_date('01-JUN-23','DD-MON-RR')); Insert into SRC.CUST (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY,UPDATE_DT) values (20,'STEVE','A','SAP','DALLAS','USA',to_date('02-JUN-23','DD-MON-RR')); Insert into SRC.CUST (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY,UPDATE_DT) values (30,'ANGELA','A','SAP','MEXICO CITY','MEXICO',to_date('02-JUN-23','DD-MON-RR')); Insert into SRC.CUST (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY,UPDATE_DT) values (40,'RAVI','A','SAP','CANCUN','MEXICO',to_date('02-JUN-23','DD-MON-RR')); Insert into SRC.CUST (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY,UPDATE_DT) values (50,'DEV','A','SAP','CHENNAI','INDIA',to_date('01-JUN-23','DD-MON-RR')); Insert into SRC.CUST (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY,UPDATE_DT) values (60,'RAJ','A','SAP','PUNE','INDIA',to_date('01-JUN-23','DD-MON-RR')); Insert into SRC.CUST (EMP_ID,EMP_NM,STATUS,SRC_CD,CITY,COUNTRY,UPDATE_DT) values (70,'MARCUS','A','SAP','AUSTIN','USA',to_date('01-JUN-23','DD-MON-RR')); express formula : COUNTRY||'.csv' #informatica #iics #informática #tutorial #etltesting #datawarehouse #sql