Performance Best Practices for Import

To obtain optimum performance when using import, consider the following points:

• Create Indexes on data source as mentioned in Data Source Indexes.
• Create separate tablespaces for each MDM tables and Indexes. For information, refer to Tablespaces Configuration and Database Optimizations on Microsoft SQL Server - Customer Study.
• If your load is large, TIBCO recommends splitting the load into smaller loads in the range of 500K and using the Import utility to load the data.
• Disable logging on the Oracle database for the following tables:
  • MCT's
  • Productkey
  • Principalkey
  • Relationship
  • Goldencopy
  • MVT
  • RCT

Copyright © Cloud Software Group, Inc. All rights reserved.