Interested to Buy Any Domain ? << Click Here >> for more details...
when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
- 1 Answers
- 4783 Views
- I also Faced
- E-Mail Answers
Answer / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is row level and column level indicator?
Is it possible to create multiple domains on a single Informatica server?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
how to calculate the optimum cache size in aggregator transformation?
have u done any performance tuning? how u ll do?
what is dimension table?
what is system requirement(SR) & business requirement(BR)?
in which situations do u go for starflake schema ?
How to load the source table into flat file target(with columns) in informatica?
explan ur project architecture?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
In dimension and fact table? which one holds big data?
Teradata 
