PowerDesigner: Write Netezza distribution type via VBScript

vbscript,netezza,powerdesigner

You shoul edit the DMBS and include in Script/Objects/Table a new Text Item named SqlDistributeOption containing this: SELECT t.owner,t.tablename, CASE WHEN (m.relid isnull) THEN 'distribute on random ' ELSE CASE WHEN (m.distseqno = 1) THEN 'distribute on hash (' ELSE ', ' END || m.attname || CASE WHEN ( m.distseqno...

PowerAMC do simple action with script

xml,vbscript,xsd,powerdesigner

I guess that would the Preview (string) property, available for all NamedObject.

Mandatory relationship m:n

database,oracle,database-design,oracle10g,powerdesigner

You would need to understand the reasons for producing a conceptual, logical and physical model. A Conceptual Model is a representation of the area of interest in a form that is understood by users. It will consist of classes of entities with attributes and the business rules regarding these. As...