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

Facebook Login
Site Registration
Print Preview

What is the diff between union, joiner and lookup?

+1 vote
221 views
posted Jul 21, 2013 by anonymous

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

2 Answers

+1 vote

Union- Can join two tables without common port.
Joiner- Can join any two heterogeneous sources, but common port is necessary.
Lookup- We can join two tables by using SQL over-ride, apart from that we can check whether the row is already existing or not.

answer Jul 21, 2013 by Shatark Bajpai
+1 vote

Joiner is a horizontal expansion of two data sources based on some condition. While Union is a vertical expansion of two sources without any condition. Lookup behaves like a detail outer join but we can't say it as a subset of joiner because in Joiner you can use only equal operator in join condition but in lookup you can use other relational opearator like > , >=, <, <=.

Union doesn't use cache but joiner and lookup may use cache. Union needs compatibilty structure to peform its opeartion but joiner and lookup doesn't need compatiblity.

answer Aug 19, 2013 by Nandan Kumar
Similar Questions
+2 votes

What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

+2 votes

Can two flat files be joined with Joiner Transformation using informatica?


Useful Links with Similar Problem
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#470/147, 3rd Floor, 5th Main,
HSR Layout Sector 7,
Bangalore - 560102,
Karnataka INDIA.
QUERY HOME
...