7. .
: (Transformation Model); (DBMS Model).
, . , . ERwin , (Subject Area). , , , .
. ERwin .
. Target Server ( Database/Choose database.. ) (. 1).
ERwin , 20 . .
Target Server NULL , , . Default Datatype, , .
Default Non-Key Null Option NULL .
. 1. Target Server
ERwin . .
, (view)
. , . Table Editor Column Editor, .
ERwin , , . , , . , Table Editor Column Editor, , ERwin .
|
|
Table Editor , , , , , . . (. 2).
. 2. Table Editor
Name . Owner , , . Physical Only . Generate, CREATE TABLE. DB Sync .
Table Editor :
Dimensional. (Dimensional Modeling).
Comment. .
Volumetrics. .
Physical Props. .
Partitions. . Oracle 8.x.
UDP. , .
Validation. .
Synonym. ( ).
Stored Procedure. .
Pre & Post Script. ( ), .
PowerBuilder. PowerBuilder.
, , Columns (. 3). , Columns.
ERwin , , Target Server. NOT NULL. NOT NULL (Inversion Entry).
. 3. Column Editor
Column Editor Attribute Editor. :
General. , .
, ( . 3 4 -ORACLE). . , NULL, . Validation Rule Editor Default/Initial Eritor. Table Properties General Validation Validation Constraint. Access, AS/400, PROGRESS Teradata .
. 4. Column Editor
Comment. .
UDP. , .
Data Source. .
|
|
Index. .
Visual Basic PowerBuilder. .
. U , U . New, Rename Delete , . Reset , , . DB Sync .
. Migrate Migrate Column Property (. 5), , .
. 5. Migrate Column Property
- Migrate Column Property, - . , -, , , -, , .
(view), , , , , , , . , . , . ERwin . . , . V_n, n - . , , (. 6). .
. 6.
View Editor (. 7). View Editor.
. 7. View Editor
View . Name , Owner- .
View Editor :
Select (. 7). : , - . New Expression . , V_43 . 6 City "_-__", , , Count(*). ERwin .
From. . , . ( Alias), SQL- .
Where. - Where, Group By Having. Erwin SQL- , SQL-. V_43 Where "1='"', Group By - "City", Having - "Count(*)>2". , , .
|
|
SQL. , SQL- User-Defined SQL. User-Defined SQL , SQL- , Select, From Where. , , .
Comment .
Stored Procedure .
Pre and Post Script , .
PowerBuflder PowerBuilder.
UDP , .
View Column Editor (. 8). View Column Editor.
. 8. View Column Editor
:
General. . , .
Select. View Editor ( Select, New Expression), ( - ) .
AS/400 Access. AS/400 Access.
Comment .
UDP , .
Data Source. .
PowerBuilder Visual Basic. PowerBuilder Visual Basic.