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
- 39297 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 do think which one is the better joiner or look up?
Explain the aggregator transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what is index?how it can work in informatica
Describe expression transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is an aggregator transformation?
Explain about cumulative Sum or moving sum?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is union transformation?
How can we use batches?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the need of etl tools?
What is sequence generator transformation in informatica?
