Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Defining a Sort Order for Results

Defining a Sort Order for Results

You can specify how you want the database to sort the results of the query. You choose the columns on which to perform the sort.
  1. In the properties pane, click the
    Sort
    tab.
  2. Click the
    Add
    icon.
    The
    Add Table Column
    dialog box opens.
  3. Find the table and expand the list of columns.
  4. Select the columns to include in the sort.
  5. Click
    OK
    .
    The selected columns appear in the Sort table. By default, columns are sorted in ascending order.
  6. If you want to sort a column in descending order, clear the check box in the
    Ascending
    column.
  7. Optionally, you can reorder or remove columns.
    Option
    Description
    Reorder
    Select the column, and click the
    Move Up
    or
    Move Down
    icon.
    Remove
    Select the column, and click the
    Delete
    icon.
  8. Click the
    Save
    icon.

0 COMMENTS

We’d like to hear from you!