What is a diff between joiner and lookup transformation
- 16 Answers
- 90881 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / gopal
In joiner we can join two heterogeneous sources for entire
records based on a condition.
But in look up only the first value or last value of the
records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
EX:
in source : No Name
1 -
Look up table: No Name
1 A
1 B
1 C
Now we can return only A or C in look up.
If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
solution.
| Is This Answer Correct ? | 66 Yes | 24 No |
Post New Answer View All Answers
Name the different lookup cache(s)?
What are the guidelines to be followed while using union transformation?
What are the new features of informatica 9.x developer?
How to do the error handling of if ur source is flatfiles?
What is the format of informatica objects in a repository?
What is data movement mode in Informatica and difference between them?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
Write the different tools in the workflow manager?
Which development components of informatica have the highest usage?
How do you convert single row from source into three rows into target?
Define mapplet?
Explain the code page compatibility?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is unit testing?tell me proceedure
