Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w union and joiner and lookup?
- 4 Answers
- 14502 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 view and materialised view?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
can u any challenge your project?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
From where we can start or use pmcmd?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
star and snowflake schema?
Teradata 
