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
- 27318 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / neetu arora
Dynamic cache is generally used when u are applying lookup
on a target table and in one flow same data is coming twice
for insertion or once for insertion and once for updation.
Performance: dynamic cache decreases the performance in
comparision to static cache since it first looks in the
whole table tht whether data ws previously present if no
thn only it inserts so it takes much tym
Static cache do not see such things just insert data as
many tyms as it is coming.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What are the differences between oltp and olap?
What do you mean by filter transformation?
What is source qualifier transformation in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the difference between source qualifier transformations source filter to filter transformation?
What is meant by active and passive transformation?
What does role playing dimension mean?
How union transformation is used?
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
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the format of informatica objects in a repository?
What are the different types of transformation available in informatica.
What is a shortcut and copy in Informatica and how two are different with each other?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
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.
