What is a diff between joiner and lookup transformation
- 16 Answers
- 92868 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
can u any challenge your project?
Can we create a Integration service without a Repository service and vice versa?
Briefly describe lookup transformation?
What is a joiner transformation and why it is an active one?
What do you understand by SOA of Informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain lookup transformation is active in informatica
What is confirmed fact in dataware housing?
Describe expression transformation?
What is lookup transformation?
How can we store previous session logs?
Explain sql transformation in script mode examples in informatica
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Define mapping and session?
