top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+1 vote
234 views

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

Why should they come up with a concept like lookup?

posted Mar 25, 2014 by Pooja Bhanout

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

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
answer Mar 25, 2014 by Shweta Singh
Similar Questions
+1 vote

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

+2 votes

If both source have same rows, same number of columns and no duplicate which one should be choosen to be master in joiner trasnformation

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...