Preface
Part 1: Introduction
Part 2: Configuring Hub Console Tools
- Configuring Access to Hub Console Tools
- Implementing Custom Buttons in Hub Console Tools
Part 3: Building the Data Model
Part 4: Configuring the Data Flow
Part 5: Executing Informatica MDM Hub Processes
- Using Batch Jobs
- User Exits
Part 6: Configuring Application Access
Appendix A: MDM Hub Properties
Appendix B: Viewing Configuration Details
Appendix C: Row-level Locking
Appendix D: MDM Hub Logging
Appendix E: Table Partitioning
- Support for Table Partitioning
Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
Appendix G: Informatica Platform Staging
Appendix H: Informatica Platform Mapping Examples
- Informatica Platform Mapping Examples Overview
- Generate Primary Keys Example
Appendix I: Glossary
- Glossary of Terms

Configuration Guide

10.4

Back Next

Defining Functions

You can add aggregate functions to the columns in your queries. For example, you can use COUNT, MIN, or MAX on the data retrieved from the column. You can also edit and remove functions from the query.

The following code sample shows a function in an SQL statement:

select col1, COUNT(col2) as c1 from table_name

In the properties pane, click the

Select

tab.

Click the

Add Function

icon.

The

Add Function

dialog box opens.

Select the column.

Select the function.

Click

The function appears in the table.

Optionally, you can edit, reorder, or remove functions.

Option	Description
Edit	Select the function, and click the Edit icon.
Reorder	Select the function, and click the Move Up or Move Down icon.
Remove	Select the function, and click the Delete icon.