What is a diff between joiner and lookup transformation
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
Why filter transformation is an active one?
How can we remove the duplicates from flat file source?
Which is the t/r that builts only single cache memory?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain dynamic target flat file name generation in informatica
What is pmcmd command?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the mapping parameters and mapping variables?
difference between informatica 8.1.1 and 8.6
How are the sources and targets definitions imported in informatica designer?
Why is sorter an active transformation?
Describe expression transformation?
What is a passive transformation?
What is workflow? What are the components of the workflow manager?
What are junk dimensions?