Skip to Content

PowerDesigner denormalisation / generate views in model transformations

Hello,

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?

Thanks!

Milan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • yesterday

    Hi,


    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.

    Regards,

    Ondrej

    Add comment
    10|10000 characters needed characters exceeded