Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU improve session performance in aggregator
transformation?
- 8 Answers
- 27712 Views
- TCS, I also Faced
- E-Mail Answers
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
How to generate or load values in to the target table based on a column value using informatica etl tool.
how to load dimension table and fact table. plz tell me the steps.
How do you load unique records into one target table and duplicate records into a different target table?
can you please explain me pre session and post session options?
What do you mean by enterprise data warehousing?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the need of etl tools?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the meaning of decode in informatica?
What are the databases that informatica can connect to windows?
What is dynamic cache?
What is workflow? What are the components of workflow manager?
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
can we override a native sql query within informatica? Where do we do it?
What is the use of source qualifier?
