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 Ma...
Please check out below videos on how to create Taskflow :
• IICS | Create First T...
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

[@kumar45512]

Very nice video

[@waseembari2125]

Hi you have very nice way of teaching,Thank you for shairng knowledge

[@ETLSTATION]

thanks

[@ETLSTATION]

Hi Friends Thank you for watching my video . Please subscribe to my channel like it and share it with your friends . also comment if you get any doubt on video , i will try to answer your doubt

[@bhushanvirat2946]

your videos are dam good to understand and analyze plz keep it posting it will be very usefull to learners like me

[@ETLSTATION]

thank you for your wonderful comment . keep watching and share with friends

[@juliburnwal9940]

can we use relational table as a target instead of a FF? it will work same?

[@OorincheMukka]

there is a extra file generated with Output1. With out that file can we generate other files with county name?