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
- 40087 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / jaspreet banga
Its better to use connected dynamic non-persistent lookup
transformation, to lookup into the traget and if record
exist , update it else insert the new using unconnected
lookup tranmsformation..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is degenerated dimension?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Do you find any difficulty while working with flat files as source and target?
What is the scenario which compels informatica server to reject files?
Differences between version 7.x and 8.x.
what is mean by complex business rule ?
What is standalone command task?
What is fact table? Explain the different kinds of facts.
define galaxy repository in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
Explain the types of transformations?
Difference between Target-based loading and constraint-based loading?
What are the different types of olap? Give an example?
What is a repository? And how to add it in an informatica client?
What are the main features of Oracle 8i with context to datawarehouse?
