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
- 12089 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 |
Make a note of the quantity vaults made in informatica?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
What are the out put files that the informatica server creates during the session running?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Differentiate between a repository server and a powerhouse?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
Explain the etl program with few examples.
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
What is union transformation?
Teradata 
