What is a look up function? What is default transformation
for the look up function?
- 2 Answers
- 16166 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 |
what is mapping override?
What is the difference b/w natural key and surrogate key
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
whatis the default data driven operation in informatica
what is the location of parameter file in informatica?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
What is the use of an aggregator cache file?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
Describe two levels in which update strategy transformation sets?
Define Incremental Aggregation?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
Teradata 
