Limit data model size

• Recommendation: Create data models with 100 tables or fewer.

• Rationale: Data models with more than 100 tables can cause performance issues.

• Additional information: If you need to, you can create smaller data models and leverage transformations to move the data. If your InForm study's source data model contains more than 100 tables:

  1. Divide the InForm Buffer Model so that each direct transformation between InForm and the Buffer handles fewer than 100 tables.

     This configuration allows several jobs to share the load and results in improved performance.

  2. Create a Union for common data sets (for example., the InForm ECG or PK sample forms) to a smaller number of target tables.

     This allows you to consolidate the multiple Buffer models into a single Aggregation layer.

     For more information about buffer models and aggregation layers, see the data model plan recommendations in the Guidance for DMW Implementation and Configuration document (Document ID: 2469980.1) on My Oracle Support.