Wednesday, October 2, 2019

ERWIN - onenote lbm


<<erwin_Overview.pdf>>

<<ERWin-DimensionalModel.pdf>>
.com/blog/erwin-tutorial/

<<4_Erwin-example_configuration and basics.pdf>>


Physical Modeling Macros - Existing Macros in ERWIN

Rename Constrains Macro Samples

Oracle Script Template
MACROS


Basic Syntax:
%If (<predicate>) {<macro code>}

Basic Syntax Example:
%ForEachAtt() {
   %If(%AttIsPK) {
        %AttName -> PK}
}

Expansion:
master-number -> PK
movie-copy-number -> PK

Full Syntax:
%If (<predicate>) {<macro code>} %Else {<macro code>}


-------------

Basic Syntax:
%Substr(<macro code>,<initial pos>)

Basic Syntax Example:
%Substr(abcdefg,4)

Expansion:
defg

Full Syntax:
%Substr(<macro code>,<initial pos>,<length>)

Full Syntax Example:
%Substr(abcdefg,4,3)

Expansion:
def

-----

Basic Syntax:
%If (<predicate>) {<macro code>}

Basic Syntax Example:
%ForEachAtt() {
   %If(%AttIsPK) {
        %AttName -> PK}
}

Expansion:
master-number -> PK
movie-copy-number -> PK

Full Syntax:
%If (<predicate>) {<macro code>} %Else {<macro code>}


---
%If (%Substr(%EntityName(),1,1)=%Upper(%Substr(%EntityName(),1,1)))
{
BT_%UPPER(%EntityName())
}
%ELSE
{
CT_BT_%UPPER(%EntityName())
}

  1. Harden the names for the entities that you do not want to apply the macro and forward engineer the scripts

Forward Engineering template

ERWIN Macro Tutorials  -



Imp ERWIN Tips


Enabling ERWIn API

Data Type Mappings


Name Hardening

Slideshow of ERWIN Data Language

Change the Naming Case

Overview of Object Naming Preferences

Bulk Editor
Erwin Docs

<<Definition_Comment_DT_Import_ r9.xlsm>>


Reports Created so Far
Source Extracts
LogicalModelReports

Erwin TLX Sample




ERWIN Ticket for Datatype conversion issue.


Important Reference



ERWIN - Target Database Properties


Library Inflections to convert CamelCase into Snake Case

ERWIn 9.8 Release Notes

How to repair corrupt model


External Organized tables

Table Options General Supplemental Logging Validation Materialized Vie n log SQL Style Icon Synonym Commen t Object Cr eab( Z] Physical Proper bes C) Regular Storage Proper bes C) Index Organization @External Organization External Pr oper tes C) Cluster Cluster Proper bes Global Temporary On Commit PRESERVE ROWS Table Compression COMPRESS DELETE ROWS NO COMPRESS

Defaults to the datatype
to Add defaults to the datatype, you need to add the default values to the domain.




Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)