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
- 34135 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
How union transformation is used?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to generate sequence numbers without using the sequence generator transformation?
Tell me about MD5 functions in informatica
Describe expression transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Performance tuning( what you did in performance tuning)
explain one complex mapping with logic? sales project?
What is the session task and command task?
What is dynamic cache?
What is confirmed fact in dataware housing?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Slowly changing dimensions, types and where will you use them
Briefly define reusable transformation?
What is rank transformation?
