What is a diff between joiner and lookup transformation
Answer Posted / eswar
Use the Joiner transformation to join source data from two
related heterogeneous sources residing in different
locations or file systems. You can also join data from the
same source. The Joiner transformation joins sources
with at least one matching column. The Joiner
transformation uses a condition that matches one or more
pairs of columns between the two sources.
Use a Lookup transformation in a mapping to look up data in
a flat file, relational table, view, or synonym.The
Integration Service queries the lookup source based on the
lookup ports in the transformation and a lookup condition.
The Lookup transformation returns the result of the lookup
to the target or another transformation.
The Joiner transformation supports only equi joins and
Lookup Transformation supports equi and non-equi joins
The Joiner transformation lieterally joins two columns
whereas Lookup transformation return a column based on the
condition, but it will not joint two columns.
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
differences between service based and product based?
What the difference is between a database, a data warehouse and a data mart?
what is index?how it can work in informatica
What you know about transaction control transformation?
Explain the shared cache and re-cache?
On which transformations you created partitions in your project?
What will be the approach?
What is a sorter transformation?
Please let me know how to make Data masking in informatica..
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Under what condition selecting sorted input in aggregator may fail the session?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?