What is a diff between joiner and lookup transformation
- 16 Answers
- 90959 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 we override a native sql query within informatica?
Plz can any one say me how to get the informatica certification materials and dumps
Mention few power centre client applications with their basic purpose?
Where is metadata stored?
permutations of mapplet
Tell me about Propagate functions in informatica
Differentiate between a repository server and a powerhouse?
What is domain and gateway node?
What happens when a session fails and you click on recover?
Differences between version 7.x and 8.x.
How is union transformation utilized?
wf dont have integration severances how you can run?
without table how to come first record only in oracle?
How can you validate all mappings in the repository simultaneously?
Explain sessions?
