top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the diff between union, joiner and lookup?

+1 vote
895 views
What is the diff between union, joiner and lookup?
posted Jul 21, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn 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

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

+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?

...