Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Configuring a single object or saved query as the source

Configuring a single object or saved query as the source

You can configure a single object or saved query as the source of a
synchronization
task.
  1. On the
    Source
    page, select a connection.
    To create a connection, click
    New
    . To edit a connection, click
    View
    , and in the
    View Connection
    dialog box, click
    Edit
    .
  2. To use a single source, select
    Single
    .
    To use a saved query, select
    Saved Query
    .
    You can use a saved query when you use a database connection.
  3. If the connection includes less than 200 objects, select a source object or click
    Select
    .
    If the connection includes more than 200 objects, click
    Select
    .
    The
    Select Source Object
    dialog box displays up to 200 objects. If the object you want to use does not display, enter a search string to reduce the number of objects that display.
    Select an object and click
    Select
    .
  4. To display technical names instead of business names, select
    Display technical field names instead of labels
    .
    This option is not available for all connection types.
  5. To display source fields in alphabetical order, click
    Display source fields in alphabetical order
    .
    By default, fields appear in the order returned by the source system.
  6. For a flat file or FTP/SFTP single source, click
    Formatting Options
    . Select a delimiter and text qualifier. Optionally, select an escape character.
    If you choose Other for the delimiter, the delimiter cannot be an alphanumeric character or a double quotation mark.
    If you choose a delimiter for an FTP/SFTP flat file,
    Data Integration
    applies the delimiter to the local file, not the remote file, when previewing and reading data. If the remote and local files are not synchronized, you might see unexpected results.
  7. If preview data does not display automatically, click
    Show Data Preview
    to preview data.
    The Data Preview area shows the first ten rows of the first five columns in the object. It also displays the total number of columns in the object.
    The Data Preview area does not display certain Unicode characters correctly. If the data contains binary data, the Data Preview area shows the following text:
    BINARY DATA
  8. To preview all source columns in a file, click
    Preview All Columns
    .
    The file shows the first ten rows of the source.
  9. Click
    Next
    .

0 COMMENTS

We’d like to hear from you!