Three options to get schema prefix in DDL SQL scripts generated in ERwin. 1. Global Setting Erwin main menu Model -> Model Properties -> Set Default Owners… 2. Local Override in the Model Open Physical view in the model Right click on the table “Table Properties…” to open Oracle Table Editor. There is a column […]
Continue ReadingWhat Business Glossary Contains
What information can I find in the Business Glossary? Business terms, synonyms, business rules, information objects (i.e. types of information for which the business holds data about such as sales orders, customers address, customer contact details), relationships between information.
Continue ReadingIs There Data Model Alias Generator online?
I liked one feature of old good Oracle Designer – it automatically generated alias and title text from table name. I always have dilemma, what alias give for table when designing relational data warehouse. Does anyone knows any tools like this online or open source?
Continue Reading