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
- 12083 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
How big was your fact table
Mention a few design and development best practices for informatica?
How do you migrate data from one environment to another?
write a query to retrieve the latest records from the table sorted by version(scd)
What is xml source qualifier transformation in informatica?
Where do we use mapping variables in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to generate sequence numbers using expression transformation?
How can we remove the duplicates from flat file source?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can we handle two sessions in informatica?
Explain the shared cache and re-cache?
What are the designer tools for creating transformations?
