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...

What is a look up function? What is default transformation
for the look up function?

Answer Posted / sri

Lookup is a transformation in Informatica which is mainly
used for obtaining the "Key" values from the dimensions.
Lookup can be connected or unconnected. If it is
unconnected then it can be used as a function but it can
return only one value.
Where as connected lookup return more than one value.
Lookup contains:
1. <Input Column/Value>
2. <Output Column(s)>
3. <Condition>

Is This Answer Correct ?    12 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is domain in terms of informatica?

957


How do you load only null records into target? Explain through mapping flow.

1958


COM components can be used in Informatica

2315


Make a note of the quantity vaults made in informatica?

945


what are the Methods For Creating Reusable Transformations?

1102


What is olap (on-line analytical processing?

1009


What is domain and gateway node?

1122


On which transformations you created partitions in your project?

1253


Difference between Data and Index Caches?

1096


How many ways are there to create ports?

1236


have u done any performance tuning? how u ll do?

2249


How an expression transformation differs from aggregator transformation?

993


How do you set a varible in incremental aggregation

1828


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1431


Define filter transformation?

1033