Interested to Buy Any Domain ? << Click Here >> for more details...
from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
- 21 Answers
- 39248 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / amarnath
using the joiner is right I have faced similar kind of
scenario in my project. if u use static it has to cache all
the 5m records and then compare the each incoming records
which will de-grade the performance, hence designate the
master record with less no of rows in joiner which is a gud
practice.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do you convert single row from source into three rows into target?
What is mapping debugger?
How to load a Dimension ? and how to load a fact table?
How can you generate reports in informatica?
Explain lookup transformation source types in informatica
How are the sources and targets definitions imported in informatica designer?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain the shared cache and re-cache?
What do you understand by SOA of Informatica?
can anyone explain me about retail domain project in informatica?
What is informatica? Why do we need it?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can you increase the performance in joiner transformation?
What are the limitations of joiner transformation?
