Page History
...
Metadata Operations and Target Database Operations
| Operation | Description |
|---|---|
| Generate Partitions |
...
...
| Provides and interface to add multiple partitions to clustered indexes. A list of tables is provided. Selecting a table will load the clustered indexes to be partitioned. The storage parameters are uniform across partitions. | |
| Get Related Tables |
...
| Selects the related parents and/or child of the selected tables. To use the macro lasso a group of entities on the diagram or select them in the diagram tree, then right click on the macro to execute. Parents and children will be selected depending if the option is checked. This macro can be used to assist in submodel creation. | |
| ImportDataDictionary - Import Data Dictionary objects from a flat file. The imported file has to follow a specific format guidelines listed in the comments with examples. | |
Index Naming - Applies naming conventions to all types of indexes. It provides an option to use the selected tables or all tables. The prefix and suffix variables can be used to add company specific conventions to the beginning and/or end of the target name. The target name can be either the existing name, table name, tablespace name or database name. The tablespace and database can only be used for applicable platforms such as Oracle or DB2. Truncate parameters can also be specified to remove the first N characters or the last N characters of the target name. Another parameter can also be used to limit the total number of characters in the target name. These are applied before the prefix and suffix are added.
...