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 session partitioning?

1 Answers  


Explain about enterprise scalability and roi of data integration suite?

0 Answers  


Explain different types of partitioning?

0 Answers  


What are the different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,


Mention few test cases and explain them?

0 Answers  


What is full load & incremental or refresh load?

0 Answers  


how do u set the size of block buffer?

1 Answers  


what happens if the info.server doesn't find the session parameter in the parameter file?

0 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  


what make u disappointmnets in u r career

0 Answers   Infosys,


what are the session parameters? How do u set them?

0 Answers  


Categories