Interested to Buy Any Domain ? << Click Here >> for more details...
What is a look up function? What is default transformation
for the look up function?
- 2 Answers
- 17050 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 |
explain about lookup t/r?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
how can we perform incremental aggregation?explain with example?
how we can do session partition in informatica any one explain me clearly? thanks advance.
how can we load starting with 11th record of a table from source to target
What is dimensional table? Explain the different dimensions.
what is plsql table?
How will you update the first four rows and insert next four rows in a mapping?
Can anyone briefly describe abt audit table loading?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
Teradata 
