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
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
Explain transaction control transformation in informatica
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is event and what are the tasks related to it?
Explain lookup transformation source types in informatica
What are the features of complex mapping?
What is the difference between stop and abort in informatica
What are the modules in Power Center
What is joiner transformation in informatica?
wat are deployement groups in informatica, how it will be used for developers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is primary and backup node?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How you prepared reports for OLAP?
How can we handle two sessions in informatica?
What is a predefined event?