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
4 окт 2024
