What is a diff between joiner and lookup transformation
- 16 Answers
- 90816 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
What is data caches/ index caches?
Differentiate between a database and data warehouse?
Difference between Target-based loading and constraint-based loading?
Tell me about MD5 functions in informatica
What are active transformations.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the transformations that are not supported in mapplet?
What is the meaning of decode in informatica?
whats the logic to load the lower level of granularity of data to fact table.
how to load rows into fact table in data warehouse
What is a node in Informatica?
What is Cognos script editor?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the new features of informatica 9.x in developer level?
