Skip to Content

PowerDesigner denormalisation / generate views in model transformations


I am generating a PDM from an LDM using transformations. I want to include a transformation which splits one table into two tables. For this, I would like to use the horizontal partitioning (Tools --> Denormalization --> Horizontal Partitioning). So far, I haven't found a way to call this function using a transformation (VBScript). Does anyone know how to do this?

Moreover, I'd like to create simple views from my tables using Tools --> Create view. Here I run into the same problem: I can't call this function using a script.

I spent a lot of time looking in the metamodel objects help but I can't seem to find how to do it, can anybody help me?



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 17 at 11:17 AM


    there is IMHO no way how you can call the Create View function through scripting, you will have to write it again for yourself.

    Regarding the horizontal partitioning, you can do that during post-generation transformation, but again, there is no one simple function to do that all, you will have to write it by yourself. For that you will need to create HorizontalPartitioning object, setup few of its attributes and also create TransformationSource object. See attached screenshot. The only thing I wasn`t bothering with, is creating newly partitioned tables with everything from their parent. I just created two empty tables (A and B) with no columns in them. So you will have to add/copy the columns from original table.



    horpart.jpg (418.7 kB)
    Add comment
    10|10000 characters needed characters exceeded