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
- 39249 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 are the main issues while working with flat files as source and as targets ?
How does a sorter cache works?
What are the components of workflow manager?
Explain what is informatica metadata and where is it stored?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How does the aggregator transformation handle null values?
What is a stored procedure transformation?
Different sorts of metadata that stores in the storage facility?
Differentiate between reusable transformation and mapplet.
What is the difference between Active and Passive transformation?
What is transformation?
Write the unconnected lookup syntax and how to return more than one column.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain the features of connected and unconnected lookup.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
