What is a diff between joiner and lookup transformation
- 16 Answers
- 90847 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 the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Different circumstance which drives informatica server to expel records?
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.
draw informatica architecture 8.6 ?
What is a connected transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Can informatica load heterogeneous targets from heterogeneous sources?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How can a transformation be made reusable?
How do you load only null records into target? Explain through mapping flow.
What are the components of the workflow manager?
What can we do to improve the performance of informatica aggregator transformation?
Explain the use of aggregator cache file?
Suppose we do not group by on any ports of the aggregator what will be the output?
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?
