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

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

0 Answers   Tech Mahindra,


what make u disappointmnets in u r career

0 Answers   Infosys,


What is the difference between Data Warehousing and Data Mining?

0 Answers  


Is hadoop a etl tool?

0 Answers  


What is etl process?

0 Answers  


What is etl tool in hadoop?

0 Answers  


Explain etl mapping sheets?

0 Answers  


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 Answers  


What is grain of fact?

0 Answers  


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

2 Answers  


Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  


What is abap? What are idocs?

0 Answers  


Categories