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
What is domain in terms of informatica?
How do you load only null records into target? Explain through mapping flow.
COM components can be used in Informatica
Make a note of the quantity vaults made in informatica?
what are the Methods For Creating Reusable Transformations?
What is olap (on-line analytical processing?
What is domain and gateway node?
On which transformations you created partitions in your project?
Difference between Data and Index Caches?
How many ways are there to create ports?
have u done any performance tuning? how u ll do?
How an expression transformation differs from aggregator transformation?
How do you set a varible in incremental aggregation
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Define filter transformation?