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
- 39299 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / swapnil
It should be un chached coz by this way the 100 records
will directly compare at the database level hence no cache
will get created and will take less time not to create
cache and compare the source records at the db level.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is informatica etl tool?
what is size of u r database?
What is primary and backup node?
How can we create index after completion of load process?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What do you mean by channel change?
What are multi-group transformations?
How to delete duplicate row using informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the different lookup cache(s)?
What is informatica?
Explain target update override in informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain the code page compatibility?
What is meant by lookup transformation?
