Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w union and joiner and lookup?
- 4 Answers
- 14567 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raveendra guturi
Union: while we have to join two sources should data
structure same.
)Joiner is active transformation
Lookup is a passive transformation
2)In joiner we can join two heterogeneous sources for
entire Records based on a condition.
But in look up only the first value or last value of the
Records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
3)If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
Solution.
4) Joiner operates on source
Lookup operates on source and target level
5) Joiner does not support non-eqijoin its support equijoin.
Lookup supports non-equijoin
6) Joiner doesnot match for null values
Lookup supports null values
7) join supports only = operator
Lookup supports <=,>=,=,1= operators
9) Joiner supports outer join but lookup doesnot.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / maruthi
union-can join two tables without common port
joiner-can join any two hetrogenous sources,but common port
is necessary.
lookup-we can join two tables by using sql over-ride,apart
from that we can check wether the row is already existing
or not.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rajesh myle
1. Lookup T/R supports Non-Equi Joins. Where as Joiner
T/R does not support the Non Equi Joins. (Joiner T/R
supports only Equi Joins(i.e. ‘=’))
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / subh
In case multiple rows are expected in the joining
condition, joiner has to be used. As look up wont be able
to return multiple rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between a connected look up and unconnected lookup?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Diff b/w ShortCut and reusabel Object ?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What is a shortcut and copy in Informatica and how two are different with each other?
How to generate a single mapping for both the historical and incremental load.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Diffrence between static and dynamic cache
WHAT IS FACT TABLES?
What does update strategy mean, and what are the different option of it?
What is xml source qualifier transformation in informatica?
Teradata 
