Explain the shared cache and re-cache?
- 1 Answers
- 1191 Views
- I also Faced
- E-Mail Answers
Answer / Vidhu Sharma
"Shared Cache" in Informatica refers to a memory space that is used by multiple tasks or sessions to store frequently accessed data. This reduces the need for unnecessary data retrieval, thus improving performance. On the other hand, "Re-Cache" is a mechanism that stores the results of an expression transformation temporarily. If the same expression is encountered again during the same session, Informatica reuses the cached result instead of recalculating it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why do you use Mapping Parameter and mapping variable?
If informatica has its scheduler why using third party scheduler?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
How to recover sessions in concurrent batches?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
What is olap (on-line analytical processing?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how can u tune u r informatica mapppings
How will you display "Mr" for male & "Mrs" for female in target table?
What are the basic needs to join two sources in a source qualifier?
Teradata 
