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
- 39307 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / arnab
Lookup with No cache will make it faster , personal opinion
though , there are other ways do it also , if you have a
common key between the source and the target and they are
on the same database , it would be easier and faster to do
a join in the source qualifier itself and let the database
handle the query rather than Informatica server
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is xml source qualifier transformation in informatica?
What is mapplet in informatica?
What are the differences between source qualifier and joiner transformation?
Define Pmrep command?
What are some examples of informatica etl programs?
What is substr in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is aggregator transformation in informatica?
Which transformation is needed while using the Cobol sources as source definitions?
Which is the t/r that builts only single cache memory?
On which transformations you created partitions in your project?
Explain the aggregator transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is domain and gateway node?
Which files are created during the session rums by informatics server?
