when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
- 1 Answers
- 4285 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 |
How can i set break points in debugging mode ? can explain steps please?
If informatica has its scheduler why using third party scheduler?
where to select code page option?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
What are differences between Informatica 7.1 and 6.1
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to generate the HTML output using Informatica.
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
Teradata 
