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
- 33897 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / prakash
USE NOCACHE,IT WILL GIVE BETTER PERFORMANCE RATHER THAN
JOINER
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is data caches/ index caches?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is pmcmd command?
What is aggregate cache in aggregator transformation?
How to load the data from people soft hrm to people soft erm using informatica?
How can we create index after completion of load process?
What is an Integration service in Informatica?
What is target load order?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
To import the flat file definition into the designer where should the flat file be placed?
What is meant by active and passive transformation?
Explain the difference between mapping parameter and mapping variable?
Explain sessions?
How do you handle two sessions in Informatica
