Interested to Buy Any Domain ? << Click Here >> for more details...
which is better perfomancewise lookup or joiner and why?can anyone give example?
- 6 Answers
- 12103 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijay pal
It depends upon the Situation...
In Homo-genous sources(both the sources are RDBMS), Joiner
has good performance
In Hetro-genous sources (like RDBMS & Flat file) look up
would be better.
But If you want RDBMS data in more than one places, better
go for Lookup than Joiner
Hope it have answered you question :)
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / 78swapnil
All you guys are correct. But there is a major difference between lookup and joiner is, when you join the table we need to join on the basis of a join condition (=) but in case of lookup you can get the data join conditions like (=,!=,<=,>=).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lokesh.t
lookup is having multiple advantages compare to joiner
transformations :-it will avoid duplicate vlues . by
using first last value in lkp values . with lkp we can n
nnumber of tables. where as in joiner we can join only
two tables
| Is This Answer Correct ? | 1 Yes | 3 No |
R u looking for flat or database file?
Generally sorted joiner more effective on flat files than lookup, because sorted joiner uses merge join and cache less rows. Lookup caches always whole file. If the file is not sorted, it can be comparable. Lookups into DB table can be effective if the DB can return sorted data fast and the amount of data is small, because lookup can create whole cache in memory. If DB responses slowly or big amt of data r processed, lookup cache initialization can be really slow.
Then it can be better use sorted joiner, which throws data to output as reads them on input.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / m.m.basha
performwise both (connected& unconnected) are best
connected lookup :-it is connected to the source
unconnected loockup:- it is not connected to the source
| Is This Answer Correct ? | 1 Yes | 12 No |
why do u use shortcuts in informatica.?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
What is the difference between bitmap and btree index?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
how can one eliminate dupliacte data with out using distinct option?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
Which will beter perform IIf or decode?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
What is data caches/ index caches?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Teradata 
