Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 96368 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
What is status code in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
What differs when we choose the sorted input for aggregator transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the prerequisite tasks to achieve the session partition?
What are the databases that informatica can connect to windows?
What is a transaction control transformation?
can we override a native sql query within informatica? Where do we do it?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
can you please explain me pre session and post session options?
How to Create a folder using pmrep command?
what is $$$$?
How union transformation is used?
What is rank index in rank transformation?
