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
- 17143 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 |
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
explain abt joiner t/r?
What are the different versions of informatica?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
how to get flatfile containg 10 records half records one target another half another target
Explain sessions and how many types of sessions are there?
Explain lookup transformation in informatica
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
plz plz plz send client names and project names in informatica?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
Teradata 
