list out all the transformations which use cache?
- 1 Answers
- 1281 Views
- Informatica, I also Faced
- E-Mail Answers
Answer / Raju Paswan
In Informatica, several transformations make use of cache for performance optimization. Here are some examples:n
1. Aggregate Transformation: It aggregates data using functions like SUM, COUNT, AVG, etc., and stores the intermediate results in a cache to improve performance.n
2. Hash Join Transformation: It performs a join operation by creating hash tables for each input stream and comparing them for matching records. The resulting matches are stored in a cache to speed up the process.n
3. Sort Transformation: It sorts data using various algorithms like Merge Sort, Quick Sort, etc., and stores the sorted data in a cache.n
4. Lookup Transformation: It performs lookups against a reference table and stores the results in a cache for faster lookup times.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the flat file partition and where have to specify it
what is informatica metadata?
what are cost based and rule based approaches and what is the difference?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
How to update a particular record in target with out running whole workflow?
How you prepared reports for OLAP?
Tell me about Propagate functions in informatica
what is shared Cache. when we will use shared Cache?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Design time, run time. If you don't create parameter what will happen
tell me the push down optimization
How you know when to use a static cache and dynamic cache in lookup transformation?
Teradata 
