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

Data transfer task sources

Data transfer task sources

You can select a single source object to transfer data from or define a custom query.
The type of source and the formatting and advanced options that you can configure for the source depend on the source connection that you select. For example, you can create a custom query for database sources that support SQL queries. For a flat file source, you can configure formatting options such as the formatting type. For Salesforce sources, you can configure advanced options such as the SOQL filter condition, row limit, and bulk query.
For information about the options that you can configure for a source connection, see the help for the appropriate connector.
You can preview the data in the source. The preview returns the first 10 rows. To preview rows in alphabetical order, select
Display fields in alphabetical order
.
Data Integration
does not change the order of rows in the actual source. You can also download the preview results as a CSV file.

0 COMMENTS

We’d like to hear from you!