Interested to Buy Any Domain ? << Click Here >> for more details...
how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 27949 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / nitin
I have a major doubt in static and dynamic cache.
1. what is the use of both?
2. while using dynamic cache(looking up target table),say a record is entering from source emp_id = 101, which is already in the target so this will be updated am i correct?
3. while using a static cache, same scenario as above the record also gets updated.
4. what happens in both the caches, when again a same record enters from the source
5. when will the record be rejected as a duplicate?
from my understanding, while using a static cache for already existing record in target. when a same record appears twice from source then the record that is appearing second time will be rejected as a duplicate. but in dyanmic cache it will not?.. is this true?
Please help me understand when the record will be rejected as a duplicate and when it will be updated, in case of dynamic and static cache
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is sequence generator transformation in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is the difference between informatica6.1 and infomatica7.1
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Clarify the utilization of aggregator cache record?
How to generate sequence numbers using expression transformation?
tell me the rules and responsblites in our project(my project is development)
What do you mean incremental aggregation?
Is it possible to create multiple domains on a single Informatica server?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
can we override a native sql query within informatica? How do we do it?
Explain dynamic target flat file name generation in informatica
How to partition the Session?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
