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 pmrep command?

0 Answers  


Explain the key challenges that you face while performing etl testing.

0 Answers  


Mention few test cases and explain them?

0 Answers  


what is a worklet?

0 Answers  


Explain etl?

0 Answers  


Two different admin users created for repository are________and_________.

1 Answers  


list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  


What are the new features of informatica 9 version?

2 Answers  


What is initial load and what is full load?

0 Answers  


What exact we can see in table?

1 Answers  


What is partitioning? Explain different types of partitioning?

0 Answers  


What are dimensions?

0 Answers  


Categories