Skip to Content
1
Former Member
Aug 02, 2016 at 06:02 PM

Splitting a Physical Data Model into two(2) separate models

157 Views

I'm wondering the best way to do this (I do not have a repository)

I'm on 16.5

I have a model for my Data Warehouse that contains both my staging tables and my DW tables. As I add more tables I realize it would be easier to manage releases to the data base with two separate models.

Should I:

1. Just make a copy (Save As) and delete the unwanted parts from each copy?

2. Generate a new model from the current one and then delete the unwanted parts from each?

3. Is there a 3rd option

Keeping in mind that I want to preserve the lineage from the LDM to the PDM DW tables. The staging tables have no such lineage (as they are clones of source tables from a COTS system) and I may or may not document Source to Target mapping from the staging tables to the DW tables in PD