what is persistant cache in which situation we will use
persistantcache
Answer Posted / reddy
parcistance cache is one of the cache which is in lookp t/r
It is used in multiple session runs.this improves the
performance.
If we wnat to run the same session more then one time then
we go for percistance cache.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
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
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Differences between connected and unconnected lookup?
How an expression transformation differs from aggregator transformation?
What is status code in informatica?
Explain how many types of dimensions are available in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
Please let me know how to make encryption and decryption with example?
What is a sequence generator transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What happens when a session fails and you click on recover?
Which means the first record should come as last record and last record should come as first record and load into the target file?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the static cache and dynamic cache in informatica?