Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Analyst
  3. Library Workspace
  4. Connections Workspace
  5. Job Status Workspace
  6. Projects Workspace
  7. Model Repository
  8. Data Objects
  9. Search
  10. Appendix A: Configure the Web Browser

Analyst Tool Guide

Analyst Tool Guide

Adding a Table

Adding a Table

Use the
New Table
wizard to add a table data object to a project. Add the table data object that you want to analyze source data for. To add a table data object, select a connection, select the schema and tables, and add the table data object.
  1. On the
    New
    header, click
    Table Data Object
    .
    The
    New Table
    wizard appears.
  2. Select a connection.
  3. Click
    Next
    .
  4. Optionally, unselect
    Show Default Schema Only
    to show all schemas associated with the selected connection.
  5. Select the table you want to add.
  6. Optionally, choose to search for a table by table name or schema name, or by table name and schema name.
    • To search for a table by table name, enter a table name in the
      Tables
      search box and click the
      Find
      icon to search by table name. Click the
      Clear
      icon to display all tables by name.
    • To search for a table by schema name, enter a table schema name in the
      Schema
      search box and click the
      Find
      icon to search by table schema name. Click the
      Clear
      icon to display all schemas by name.
    • To search for a table by table name and schema name, enter a table name in the
      Tables
      search box and a schema name in the
      Schema
      search box and click the
      Find
      icon to display all tables by name in schemas by name. Click the
      Clear
      icon to display all schemas by name.
  7. Optionally, on the
    Properties
    tab, view the properties and column metadata for the table.
  8. Optionally, click the
    Data Preview
    tab to view the columns and data for the table.
  9. Click
    Next
    .
  10. Select a project or folder in the
    Folders
    panel where you want to add the table.
    The
    Tables
    panel displays that tables that exist in the project or folder.
  11. Click
    Finish
    .

0 COMMENTS

We’d like to hear from you!