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

Target prefixes

Target prefixes

When you replicate data to a database table or flat file, the
replication
task names each database table or flat file based on the corresponding source object name.
By default, the
replication
task includes the target prefix SF_. For example, the default flat file name for the Account Salesforce object is
SF_ACCOUNT.CSV
. If you remove the default target prefix and do not specify another prefix, the
replication
task creates a flat file or database table with the same name as the corresponding source object.
You can use target prefixes to prevent overwriting data. For example, you and another user share a database user account. The other user ran a
replication
task on the Contact object from her Salesforce account. Her
replication
task created a database table named Contact in the shared database. You use no target prefix and run a
replication
task on the Contact object from your Salesforce account. The
replication
task overwrites the data in the existing Contact table with your data. If you use the SF_ prefix, the
replication
task creates a table named SF_CONTACT and does not overwrite the existing table named Contact.

0 COMMENTS

We’d like to hear from you!