Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95265 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Write the advantages of partitioning a session?
What is confirmed fact in dataware housing?
How we can create indexes after completing the load process?
What is a surrogate key?
What is intricate mapping?
What is deployment group?
differences between service based and product based?
What does “tail –f” command do and what is its use as an Informatica admin.
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the new features of informatica 9.x at the developer level?
Define the various join types of joiner transformation?
How many dimensions are there in informatica?
What is persistent lookup cache?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
