Informatica Common components aggregator four create aggregation transformations

• In Mapping Designer, select Convert-Create. Select the aggregation transformation.

• Enter a name for the aggregation, and click Create. then click Finish.

Designer to create an aggregation transformation.

• Drag the desired port to the aggregation transformation.

Designer will create an input/output port for each port you include.

• Double-click the transform title bar to open the Edit Transform dialog box.

• Select the Ports tab.

• Click the Group by option for each column that you want to aggregate when you create the group.

You can choose to enter a default value to replace an empty group.

If you want to use a non-aggregate expression to modify the group, click the Add button and enter the name and data type of the port. Clear input (I) to make this port an output port. Click the right corner of the expression field, enter a non-aggregate expression using one of the input ports, and then click OK. Select GROUP BY.

• Click Add and enter a name and data type for the aggregation expression port. Clear input (I) to make this port an output port. Click the right-hand corner of the expression field to open the expression Editor. Enter an aggregation expression, click Validate, and then select OK.

Ensure that the expression is validated before closing the expression editor.

• Add default values for specific ports as needed.

If a port may contain null values and the target database does not handle null values, you may want to specify a default value.

• Select the Properties tab.

Select and modify these options as needed:

Aggregation Settings	Description
Cache Directory	PowerCenter Server creates a local directory of indexes and data cache files. By default, PowerCenter server uses the directory entered in Workflow Manager for server variable $PMCacheDir. If you enter a new directory, make sure that the directory exists and contains enough disk space for the aggregated cache.
Tracing level	Displays the amount of detail in the session log for this conversion.
Sorted Input	Indicates that the input data has been pre-sorted by group. Select this option only if the map passes the sorted data to the aggregation transformation.
Aggregator Data Cache Size	The converted data cache size. The default cache size is 2,000,000 bytes. If the total cache size for the session configuration is 2 GB (2,147,483,648 bytes) or more, you must run the session on the 64-bit PowerCenter Server.
Aggregator Index Cache Size	The index cache size for the conversion. The default cache size is 1,000,000 bytes. If the total cache size for the session configuration is 2 GB (2,147,483,648 bytes) or more, you must run the session on the 64-bit PowerCenter Server.
Transformation Scope	Specifies how PowerCenter Server applies the transformation logic to receive data: Transaction. Applies the transformation logic to all rows in the transaction. Select Transaction if the data row depends on all rows in the same transaction, but not on the rows in the other transaction. All Input. Applies the transaction logic to all incoming data. When "All Input" is selected, the PowerCenter discards the receipt of the transaction boundary. If the data row depends on all rows in the source, select all Input. For more information about conversion scopes, see "Understanding Submission Points" in the Workflow Management Guide.

• Click OK.

• Select Library-Save to save the changes you made to the map.

Informatica Common components aggregator four create aggregation transformations