What is a look up function? What is default transformation
for the look up function?
- 2 Answers
- 16122 Views
- ASM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
look up compares the source to target.it update and insert
the new rows to the target.
the default transformation for look up is source qualifier
| Is This Answer Correct ? | 13 Yes | 9 No |
How can we create index after completion of load process?
What is Cognos script editor?
Difference between Data and Index Caches?
In target table how to display the system time
in which situations do u go for scds ?
where actually the usage of push down optimization happens...
How to run a session, which contains mapplet?
What is data caches/ index caches?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Explain the flow of data in Iinformatica?
What is informatica? Why do we need it?
Teradata 
