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 a test load?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
Explain about hash partitioning?
Eliminating of duplicate records without using dynamic lookups
Hi, Lookup() is what kind of join ?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
What are the different Lookup methods used in Informatica?
what is the advantage of persistent cache? when it should be used?
what is Forward,Reverse and Re_engineering?
tell me few points when u become TL
what are business components in Informatica?