which is better perfomancewise lookup or joiner and why?can anyone give example?
Answer Posted / 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 |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the settings that you use to configure the joiner transformation?
How does a sorter cache works?
What are the advantages of informatica?
What are ETL Tools?
What are Dimensional table?
Why do you use Mapping Parameter and mapping variable?
explain about unit testing? in real time?
What are some examples of informatica etl programs?
What is session task and command task?
what is INFORMATICA TESTING process
What is the fact table?
Explain the shared cache and re-cache?
What is joiner transformation?