Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95917 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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is the complex transformation you used in informatica
What is union transformation in informatica?
How to load data in informatica ?
What does refresh system mean, and what are its distinctive choice?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are connected or unconnected transformations?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the advantages of using informatica as an etl tool over teradata?
Explain the scenario which compels informatica server to reject files?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Why is sorter an active transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What is difference between a gateway node and worker node?
Explain the aggregator transformation?
