Wait to create staging tables

  • Recommendation: Create staging tables only when the Aggregation Layer and the desired Consumer model are defined, and the transformation is known.

    Avoid defining staging tables on the fly within the target data model.

  • Rationale: The Create Staging Table functionality has limitations. As a result, we do not recommend using it.

  • Additional information: The Guidance for DMW Implementation and Configuration document contains details for creating staging data models that partition the intermediate steps from the target models that are intended for consumption.