What is aggregate cache in aggregator transforamtion?

Answer Posted / ram kumar

Cache is used to increase the performance of the mapping.
There r 2-typs of cache: Data & Index Cache

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1539


What are the new features of informatica 9.x in developer level?

572


Different circumstance which drives informatica server to expel records?

565


What is fact table? Explain the different kinds of facts.

623


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

633






I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1116


How can we use batches?

614


How would you copy the content of one repository to another repository?

565


What is InformaticaPowerCenter?

702


How to update a particular record in target with out running whole workflow?

1167


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

793


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1219


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1420


What are the types of caches in lookup?

586


What is powercenter on grid?

706