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
Partition, what happens if the specified key range is shorter and longer
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Write the unconnected lookup syntax?
How many types of sessions are there in informatica.please explain them?
What do you understand by term role-playing dimension?
What is meant by a domain?
What is the function of look up transformation?
What is update strategy transform?
What is the format of informatica objects in a repository?
Explain how many types of dimensions are available in informatica?
Explain about cumulative Sum or moving sum?
What are different types of transformations available in informatica?
What is lookup transformation?
What are the new features of informatica 9.x developer?