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
- 40657 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
Write the prerequisite tasks to achieve the session partition?
If informatica has its scheduler why using third party scheduler?
What is joiner change?
can anyone suggest best free Talend data integration training online
What is standalone command task?
Explain transaction control transformation in informatica
How many dimensions are there in informatica?
Performance tuning( what you did in performance tuning)
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a dimensional model?
How do you promote a non-reusable transformation to reusable transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How would you copy the content of one repository to another repository?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What do you mean by enterprise data warehousing?
