How can yoU improve session performance in aggregator
transformation?
Answer Posted / swetha
Use sorted input.
The aggregator stores data in the aggregate cache until it
completes aggregate calculations. When u run a session that
uses an aggregator transformation, the informatica server
creates index and data caches in memory to process the
transformation. If the informatica server requires more
space, it stores overflow values in cache files.
Is This Answer Correct ? | 13 Yes | 5 No |
Post New Answer View All Answers
Difference between Data and Index Caches?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the difference between Active and Passive transformation?
How do you migrate data from one environment to another?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
where to store informatica rejected data?
How to create the source and target database connections in server manager?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is depict expression change?
What is a pre-defined event and user-defined event?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is rank transform?
What is rank transformation in informatica
write a query to retrieve the latest records from the table sorted by version(scd)