What is a look up function? What is default transformation
for the look up function?
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 the difference between informatics 7x and 8x and what is latest version?
Explain the code page compatibility?
What are mapplets?
What is the difference between warehouse key and surrogate key?
Why we select the table which has minimum number of records as Master table in joiner?
How do you load alternate records into different tables through mapping flow?
Why filter transformation is an active one?
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
Describe expression transformation?
what is surrogate id ?
whatis the default data driven operation in informatica