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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What is complex mapping?
what is unit testing?tell me proceedure
Design a mapping to load a target table with the following values from the above source?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the advantages of using informatica as an etl tool over teradata?
What's the layout of parameter file (what does a parameter file contain?)?
Mention a few design and development best practices for informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what is the hint? how to use it to reduce the query processing in program?
What is the difference between writing a joiner query in ANSI style and THETA style?
How many numbers of sessions can one group in batches?
Can we create a Integration service without a Repository service and vice versa?
What is the use of target designer?