Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


if u can't find what you are looking for in lookup table,
how do you handle?



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

Post New Answer

More ETL Interview Questions

what is a test load?

3 Answers  


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

1 Answers  


Explain about hash partitioning?

0 Answers  


Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,


Hi, Lookup() is what kind of join ?

6 Answers   Satyam,


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  


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

2 Answers  


What are the different Lookup methods used in Informatica?

0 Answers  


what is the advantage of persistent cache? when it should be used?

2 Answers  


what is Forward,Reverse and Re_engineering?

0 Answers  


tell me few points when u become TL

0 Answers   Infosys,


what are business components in Informatica?

2 Answers  


Categories