What is a diff between joiner and lookup transformation
- 16 Answers
- 90883 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / sweta kedia
. I) Joiner is active transformation & lookup is passive
transformation.
II) Joiner operates on sources where as lookup operates
source as well
as target.
III)Joiner doesnt support nonequi joins whereas lookup
supports nonequi join
i.e. joiner transformation supports only equality operator
in condition of join where as lookup transformation can
support<=,>=,=,!= in the lookup condition.
IV) Lookup uses dynamic and static cache where as a joiner
doesn’t.
V) Joiner transformation does not match for null values
whereas lookup transformation matches for null values.
VI) Joiner will do left outer,right outer,normal,full outer
types of joins whereas lookup will do only left outer join.
| Is This Answer Correct ? | 34 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 a surrogate key?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how to load rows into fact table in data warehouse
Suppose we do not group by on any ports of the aggregator what will be the output?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How is union transformation utilized?
What is a sorter transformation?
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.
how we can load rejected record's at run time?(not through bad files)
Can informatica load heterogeneous targets from heterogeneous sources?
What is informatica etl tool?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is workflow? What are the components of workflow manager?
What do you mean by channel change?
