Preface
Product Overview
Before You Begin
Tutorial Lesson 1
Tutorial Lesson 2
- Creating Source Definitions
  - Viewing Source Definitions
- Creating Target Definitions and Target Tables
  - Creating Target Definitions
  - Creating Target Tables
Tutorial Lesson 3
Tutorial Lesson 4
Tutorial Lesson 5
- Creating a Mapping with Fact and Dimension Tables
- Creating a Workflow
Tutorial Lesson 6
Appendix A: Naming Conventions
- Suggested Naming Conventions
  - Naming Convention
Appendix B: Glossary
- PowerCenter Glossary of Terms

Getting Started

10.5.1
- 10.5
- 10.4.0

Back Next

Entering Remaining Aggregate Calculations

Next, enter the remaining aggregate calculations.

Enter and validate the expressions for the other output ports.

The following table describes the output ports and expressions:

Port	Expression
OUT_MIN_PRICE	MIN(PRICE)
OUT_AVG_PRICE	AVG(PRICE)

Both MIN and AVG appear in the list of Aggregate functions, along with MAX.

Click

to close the

Edit Transformations

dialog box.

Click

Repository

Save

When you save changes to the repository, the Designer validates the mapping. You can notice an error message indicating that you have not connected the targets. You connect the targets later in this lesson.

Rename Saved Search

Table of Contents

Getting Started

Getting Started

Entering Remaining Aggregate Calculations

Entering Remaining Aggregate Calculations