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
- 12254 Views
- TCS, I also Faced
- E-Mail Answers
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
What is domain and gateway node?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the format of informatica objects in a repository?
What does cheating measurement mean?
Enlist the tasks for which source qualifier transformation is used.
How to call shell scripts from informatica?
Can you use flat files in Mapplets.
Write the advantages of partitioning a session?
Clarify the utilization of aggregator cache record?
What do you mean by worklet?
What is lookup transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the different types of transformation available in informatica.
Enlist the differences between database and data warehouse.
What is a node in Informatica?
