What is a look up function? What is default transformation
for the look up function?
- 2 Answers
- 16310 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 primary and backup node?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
When do you use sql override in a lookup transformation?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
What are the informatica performance improvement tips
What are junk dimensions?
What are the active and passive transforamtions?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
Under what condition selecting sorted input in aggregator may fail the session?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
Teradata 
