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
- 40105 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / arnab
Lookup with No cache will make it faster , personal opinion
though , there are other ways do it also , if you have a
common key between the source and the target and they are
on the same database , it would be easier and faster to do
a join in the source qualifier itself and let the database
handle the query rather than Informatica server
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
Target increases every day even though no new record was inserted
what are factless facts? And in which scenario will you use such kinds of fact tables.
which one is better performance wise joiner or look up
How can we use mapping variables in informatica? Where do we use them?
What is complex mapping?
Is it possible to use a client with different version than that of its Informatica server?
what is degenerated dimension?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain the pipeline partition with real time example?
What do mean by local and global repository?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is $$$$?
Write the unconnected lookup syntax and how to return more than one column.
What are the tuning techniques you applied during your last project
