CODEWITHSUNDEEP
informaticainformatica-powercenter
jest
jest

Reputation: 699

Why joiner doesn't have not equal to operator in Informatica?

Why doesn't Informatica's joiner transformation support !=, >=, <= operators?

Why should they come up with a concept like lookup?

Upvotes: 1

Views: 5674

Answers (2)

user1688725
user1688725

Reputation: 21

Now you can join heterogeneous sources with a non-equi join condition using a Lookup Transformation's "Multi Match" feature

You can download sample from following Informatica Marketplace

https://community.informatica.com/solutions/mapping_multi_match_lookup_join

Upvotes: 0

Ruchi
Ruchi

Reputation: 679

Joiner transformation is used for vertical consolidation. e.g

order-tbl
order-id, item-id, item-qty

item-tbl
item-id, item-price, item-desc

Using a join condition on order-tbl.item-id = item-tbl.item-id you could print a report like this

order-id, item-id, item-price, item-desc

For vertical consolidation, I can't think of a scenerio needing other conditions like !=, >=, <=.

With lookup transformation, some core ETL tasks are made easy like

  1. identifying if the incoming record is a new record (primary key doesn't exist) or an update to the existing record;

  2. lookup a value e.g. lookup item-price from item-tbl to calculate order total.

Upvotes: 2

Related Questions