Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Defining Ranges

Defining Ranges

The Designer creates source definitions based on ranges you define in Microsoft Excel. You can define one or more ranges in a Microsoft Excel sheet. If you have multiple sheets, define at least one range for each sheet. When you import sources in the Designer, each range displays as a relational source.
You must define a range in the Designer to import the Excel source definition.
To define a range:
  1. Open the Microsoft Excel file.
  2. Highlight the column or group of columns of data to import.
  3. Click Insert > Name > Define.
  4. Enter a name for the selected range and click OK.
  5. If you have multiple sheets, select each sheet and repeat steps 2 to 4 to define ranges for each set of data.
  6. Click File > Save.


Updated June 25, 2018