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
Answer Posted / kt
Coolboy answer is correct , if you just want to join.
When u want to update the target then we hsould use DYNAMIC
cache.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
Difference between Target-based loading and constraint-based loading?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the different lookup cache(s)?
How can a transformation be made reusable?
What is the use of an aggregator cache file?
What is decode in static cache?
What are the types of caches in lookup?
Is there any target staging area in informatica not staging area
Parameter and variable differences
What is a surrogate key?
is it possible to index the data in cache of lkp transformation ?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is meant by a domain?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?