What is a look up function? What is default transformation
for the look up function?
- 2 Answers
- 16151 Views
- ASM, TCS, I also Faced
- E-Mail Answers
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
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is a connected transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
my source is junk data how will u remove that junk data by using unix please any one replay me
list out all the transformations which use cache?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Differentiate between Load Manager and DTM?
What is a sequence generator transformation?
What is the maplet?
COM components can be used in Informatica
How are the sources and targets definitions imported in informatica designer?
How to elaborate powercenter integration service?
How many number of sessions can one group in batches?
What is depict expression change?
What all are steps in up gradation of Informatica server?
