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
- 40661 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 workflow? What are the components of workflow manager?
Define the various join types of joiner transformation?
What is confirmed fact in dataware housing?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to configure mapping in informatica?
Explain informatica architecture - version 8 / 9
What does role playing dimension mean?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain what are the different types of transformation available in informatica.
What is a repository manager?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to update or delete the rows in a target, which do not have key fields?
Can we create a node as a gateway node and the same node can be assigned to a grid?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
