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. Naming Conventions
  11. Glossary

Getting Started

Getting Started

Previewing Data

Previewing Data

You can preview the data that the PowerCenter Integration Service loaded in the target.
  1. Open the Designer.
  2. Click on the
    Mapping Designer
    button.
  3. In the mapping m_PhoneList, right-click the target definition, T_EMPLOYEES and click
    Preview Data
    .
    The
    Preview Data
    dialog box appears.
    The following image shows
    Preview Data
    dialog box:
     The Preview Data dialog box includes ODBC Data Source, Username, Owner Name, Password, and Table Name fields. It also includes a Connect button.
  4. In the ODBC data source field, select the data source name that you used to create the target table.
  5. Enter the database username, owner name and password.
  6. Enter the number of rows you want to preview.
  7. Click
    Connect
    .
    The
    Preview Data
    dialog box displays the data that you loaded to T_EMPLOYEES.
  8. Click
    Close
    .
    You can preview relational tables, fixed-width and delimited flat files, and XML files with the Preview Data option.

0 COMMENTS

We’d like to hear from you!