What is a diff between joiner and lookup transformation
Answer Posted / swathi naik
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 ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are connected or unconnected transformations?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain transaction control transformation in informatica
How you can differentiate between connected lookup and unconnected lookup?
State the differences between sql override and lookup override?
write a query to retrieve the latest records from the table sorted by version(scd)
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the popular informatica products?
What is decode in static cache?
What is a node in Informatica?
Write the unconnected lookup syntax and how to return more than one column.
Explain the types of lookup transformation?
Explain how to import oracle sequence into informatica?
What are the types of lookup transformation?
What is dimensional table?