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
- 17043 Views
- ASM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by active and passive transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Write the program through which the records can be updated?
What are the different options available for update strategy?
How many ways are there to create ports?
What is xml source qualifier transformation in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is data transformation manager process?
What is the procedure for creating independent data marts from informatica 7.1?
What does update strategy mean, and what are the different option of it?
what are 3 tech challenges/ common issues you face?
Explain joiner transformation in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How would you join a node to the already existing domain?
Please let me know how to make Data masking in informatica..
