Getting Started

10.5.6
- 10.5.1
- 10.5
- 10.4.0

Back Next

Creating a Mapping with Aggregate Values

In the next step, you create a mapping with the following mapping logic:

Finds the most expensive and least expensive item in the inventory for each manufacturer. Use an Aggregator transformation to perform these calculations.

Calculates the average price and profitability of all items from a given manufacturer. Use an Aggregator and an Expression transformation to perform these calculations.

You need to configure the mapping to perform both simple and aggregate calculations. For example, use the MIN and MAX functions to find the most and least expensive items from each manufacturer.

Tutorial Lesson 4

Creating a Mapping with T_ITEM_SUMMARY

Creating an Aggregator Transformation

Creating an Expression Transformation

Creating a Lookup Transformation

Connecting the Target

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal