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
- 33901 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 the use of an aggregator cache file?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Difference between Target-based loading and constraint-based loading?
How to create Target definition for flat files?
What is the scenario which compels informatica server to reject files?
Explain transaction control transformation in informatica
How to generate sequence numbers using expression transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Different sorts of metadata that stores in the storage facility?
Have you worked with/created Parameter file
What is mapplet in informatica?
Slowly changing dimensions, types and where will you use them
What are the transformations that are not supported in mapplet?
What are mapplets? How is it different from a Reusable Transformation?
Write the different tools in the workflow manager?
