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

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,


Define Dynamic push down optmization?

0 Answers   HP,


Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

1 Answers   IBM, Saama Tech, Wipro,


Compare etl & elt?

0 Answers  


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


what is session partitioning?

1 Answers  


What is Relational Integrity?

1 Answers  


When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  


Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  


What are the ETL Testing Operations?

0 Answers  


How we can see table structure?

2 Answers   iGate,


Can u access a repository created in previous version of Informatica?

1 Answers  


Categories