Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • PowerCenter 10.5.8
  • All Products

Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Appendix A: Naming Conventions
  11. Appendix B: Glossary

Getting Started

Getting Started

Back Next

Entering Remaining Aggregate Calculations

Entering Remaining Aggregate Calculations

Next, enter the remaining aggregate calculations.
  1. 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.
    The following image shows the ports configured for the Aggregator transformation:
    ""
  2. Click
    OK
     to close the
    Edit Transformations
     dialog box.
  3. 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.
0 COMMENTS
We’d like to hear from you!