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

How can we handle two sessions in informatica?

1091


What is a repository manager?

1146


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2477


What are the informatica performance improvement tips

1149


wf dont have integration severances how you can run?

1985


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1096


How many transformations can be used in mapplets.

1980


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1152


What is union transformation in informatica?

1189


What is dimensional table?

1130


Briefly explain the aggregator transformation?

1063


What are some examples of informatica etl programs?

983


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1208


What does role playing dimension mean?

1086


What are roles and groups and benefits of using them?

1099