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
- 40670 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / swapnil
It should be un chached coz by this way the 100 records
will directly compare at the database level hence no cache
will get created and will take less time not to create
cache and compare the source records at the db level.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
4 yrs etl devloper roles and responsibilities?any body give solutions
What is union transformation in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is informatica metadata and where is it stored?
I have a flat file, want to reverse the contents of the flat file
Explain the etl program with few examples.
Write the unconnected lookup syntax and how to return more than one column.
What is the difference between router and filter?
Can anyone tell me the new features in Informatica 9 Version?
Why update strategy and union transformations are active? Explain with examples.
How to join three sources using joiner? Explain though mapping flow.
How to call shell scripts from informatica?
What is different between the data warehouse and data mart?
What is domain in terms of informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
