IICS | Pass data from one Mapping Task to Another in a Taskflow Informatica Cloud

[@ETLSTATION]

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"

[@chenv7413]

Nice explanation

[@ETLSTATION]

Thank you buddy. keep watching

[@ramyasri8272]

A good scenario covered. Better approach than using assign task. Thank you

[@ETLSTATION]

thank you

[@gauravpandey4646]

Please keep it up Roshan..👍

[@ETLSTATION]

thank you gaurav

[@pullaiahgarlapati4062]

Hi Bro ,
Can we convert the string to date by using meta data editing instead of using the to date function?

[@ETLSTATION]

how we will know the format of your input date value if its yyyy mm dd or mmyydddd or ddmmyyyy with second or milsecond or nanosecond .

[@ETLSTATION]

date to string , number to string all this are fine because string can take them as implicit conversion but string to date , string to number may not work since date and number format are defined at database and you must load data in those format else error will come

[@ramyasri8272]

Hi Roshan, meta data editing is good option. when it comes to format, we will definitely get the sample file from source, and according to that we can create separate flat file connection, which helps in reducing multiple column type conversions.
we can change number,date types in mapping in meta data according to target table definition. Pls do share your views.

[@vijaykrishnachari3175]

Hi Roshan, how to implement loop mechanism using Jump step and Decision task in IICS taskflow...and how can we restrict the loop mechanism for specific count(for eg loop only 3 times)...

[@ETLSTATION]

its in my list of future videos if you would seen my post , it will come soon

[@bradyb2415]

Hi @Roshan , Can you make a elaborative video on Input Macro Field and Output Macro Field ?

[@ETLSTATION]

okay i will see if its available in free version , will create it

[@manojkumarhubale4191]

Thanks for the IICS videos. Videos are very helpful.
Could you please help us to know how to remove/delete the footer/control line record from source file before loading to the target table.

[@ETLSTATION]

replied in other msg chain

[@chetan5697]

Thank you sir...
Sir i have done ETL Testing course recently but not getting calls, so i am thinking to learn new tool like any one of the below
power bi or iics or PLSQL
Please guide me which one is good?

[@ETLSTATION]

iics plus pl sql knowledge is good combination

[@chetan5697]

@@ETLSTATION Thank you Sir

[@SaiTeja-pw6iq]

Hi Roshan, can you suggest sources for learning CAI

[@siva.etliics]

Please do one video on the below requirement.
How to load unique records in one target and duplicate records in other target with minimum one occurrence?

[@ETLSTATION]

its already there buddy in my playlist , kindly check in my playlist

[@siva.etliics]

Source:
col1 col2
emp_id salary
emp_id address
emp_id department
10 10000
10 Pune
10 Data Analytics
20 20000
20 Mumbai
20 Web development
How to load the above data into 3 targets like below in iics? please do one video on this.
Target:1
emp_id salary
10 10000
20 20000
Target:2
emp_id address
10 Pune
20 Mumbai
Target:3
emp_id department
10 Data Analytics
20 Web development

[@ETLSTATION]

i think we already covered it in one of my video , 1st record goes to 1st table that one , did you check that video

[@ETLSTATION]

IICS | Load 1st Row to 1st Tbl | 2nd Row 2nd Tbl |3rd Row to 3rd Table & so on in Informatica
ua-cam.com/video/bh4xwPAw2dE/v-deo.html

[@BinodSingh-r7e]

hi