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
- 34050 Views
- Deloitte, I also Faced
- E-Mail Answers
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 main use of mapplet?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain the difference between mapping parameter and mapping variable?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What will be the approach?
What is target load order?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to improve the performance of a session using sorter transformation?
What are the databases that informatica can connect to windows?
Explain pushdown optimization $pushdownconfig parameter - informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is blocking transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is powercenter on grid?
