Informatica Interview Question | iLink Digital | TCS | Deloitte | HCL| Lookup Transformation.

Source emp details, ID, name, gender_code (M, F, any others), lookup gender table(gender_code, gender_desc) two columns. Need to get the gender details using lookup and load it into the target table? source ID, name, gender_code Target ID, name, gender_code, gender_desc Connected lookup --- Multiple return values Un connected lookup -- single return value -- Exp transformation is must :LKP_LKPTRANS(Passing Filed) Please subscribe to my channel and let me know if you have any questions. Please reach out to me for Informatica Training for Beginners or experienced or who are looking to jump into IT Sector. What's app/ping me: 6360407797 Thanks, Adike's Info Tech