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
- 11983 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
Do you find any difficulty while working with flat files as source and target?
What is the status code in stored procedure transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is data transformation manager process?
What are the types of caches in lookup? Explain them.
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the Process to creating lookup transformation in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a difference between complete, stop and abort?
Did u used latest transformations of 8.6.0? for what?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is an Integration service in Informatica?
How to update or delete the rows in a target, which do not have key fields?
Explain the shared cache and re-cache?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
