if u can't find what you are looking for in lookup table,
how do you handle?
Answer / raj.arjunan
This Depend on the situation,
To Check the value is there or not there two ways
1. Use notfound function (if possible)
2. Check the Key value from lkp as NULL
Than based on the requirement generate error/Put default
value
Is This Answer Correct ? | 0 Yes | 2 No |
What is data modeling and data mining?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
how to connect to a flatfile through ftp in informatica
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
what is the difference between normal & bulk loading? and which one is recommended ? why?
how do u implement unconn.stored proc. in a mapping?
What is lookup table in etl testing?
What are the differences between sql override and update override?
What are your responsibilities as an etl tester?
what are the session parameters? How do u set them?
what is the indicator file and where it is used?
how do u identify the changed records in operational data?