IICS EXAMPLE 34 : Unconnected Lookup on multiple port

Unconnected lookup on multiple port
First we take source then we take unconnected lookup and and we concatenate columns in look up and make it as one output.
Then in expression transformation by using instring substring we separate the columns and we send appropriate to target.
Lets see..
Here we are giving dept id and dept name alias
Here we created in expression transformation one variable port that takes both department name and location id with ~operator in between
We used o_dept_name to get the dept name by using substr operation as we seen.
Same like o_dept_loc_id we are having locaton id has 4 digits that’s why we are given -4
We see substring and instring operation in sql then it is very easy you know.
The cloud is taking much time to save
Like this we will store with single port we catch multiple row data using expression we segregate into appropriate field.
Thank you pls subscribe and like….

informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial

informatica intelligent cloud services, iics informatica tutorial, iics to cloud data base connection, iics data integration tutorial, iics cloud data integration services, iics training informatica, iics tutorial for beginners, iics informatica tutorial telugu, iics informatica, iics informatica interview questions, iics informatica resume, iics informatica training, iics data integration, iics data integration interview questions, what is informatica iics, iics login issue, informatica intelligent cloud services, iics, iics Informatica Cloud secure agent,