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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference steps for data modeling?

2149


What are various etl tools in the market?

1015


What is tracing level? How many types of transformations supported by sorted input?

980


what is pmrep command?

2446


What is grain of fact?

988


flat filevalidation in informatica

2160


explain the methodology of Data Warehousing?(Polaries)

2025


Explain me ETL project architecture in Detail?

2379


What are the different Lookup methods used in Informatica?

925


What is tracing level?

1078


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

988


What is full load & incremental or refresh load?

1211


What are the three tiers in etl?

1117


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

1941


what is a worklet?

999