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
- 33928 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
Explain about Informatica server process that how it works relates to mapping variables?
what is $$$$?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the different lookup cache(s)?
What is Index Caches size?
What are the different clients of powercenter?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is repository manager?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Separate from a database, an information bazaar, and an information stockroom?
What are the types of schemas we have in data warehouse and what are the difference between them?
Which version configuration tool used in ur project?
Explain how to import oracle sequence into informatica?
Explain sessions. Explain how batches are used to combine executions?
Define mapping and session?
