Table and Index Storage Parameters for new tables / indexes

When you use the Generate Physical Model feature, page 4 of the wizard allows you to set (based on the target platform) the default Table and Index storage parameters to be assigned to the newly created physical objects.  But when you do a Compare and Merge from Logical to Physical where a new object will be created in a Physical model, there is no such ability to define defaults.  I tried using a macro to set the storage parameters in the objects in the Logical Model, and verified that those values are assigned in the Logical objects through the API, however when the objects are created in the Physical by the C&M, the parameters are empty.  In other words, the parameter values were not pulled from the Logical objects into the Physical, they were ignored and left unpopulated in the Physical.

I know there is a sample macro for populating the properties, and in fact I have my own macro that does this, I was just surprised that the C&M wouldn't just pull over the values from the Logical.  Although there is no way to populate them in the Logical using the UI, the API does allow them to be populated in the Logical.  Seems like there wouldn't be any harm in pulling them from Logical to Physical with other properties when doing C&M...

If you're wondering why this would be an issue, it is because we have Data Analysts that do the Logical Modeling, and DBAs that do the Physical modeling.  Since the Generate can only be run once, all tables and indexes created after that are missing storage parameters unless the DBA remembers to populate them or to run a macro to do so.  The earlier in the process that we can catch such omissions, and the more accurate the generated DDL from the tool is, the better it is for Devops automation.   DBAs are more likely to notice undesirable storage parameter settings after the DDL has been generated, and then will just edit the DDL directly rather than go back through the tool to fix it.  

Anyone else see this as an issue, or trying to get to the holy grail of Devops automation - no hand editing of generated DDL?

Parents Reply Children
No Data