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
How can we handle two sessions in informatica?
What is a repository manager?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the informatica performance improvement tips
wf dont have integration severances how you can run?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many transformations can be used in mapplets.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is union transformation in informatica?
What is dimensional table?
Briefly explain the aggregator transformation?
What are some examples of informatica etl programs?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What does role playing dimension mean?
What are roles and groups and benefits of using them?