Description: How can I verify if a model has duplicate columns in erwin DM?
Solution: There are multiple ways to check if you have duplicate columns.
Option 1: Bulk Editor.
- Open your model. Go to View | Windows and select the Bulk Editor Pane to activate that. The Bulk Editor will appear.
- On the Bulk Editor, press the icon Invoke Bulk Editor Wizard.
- Under Object Types, check on column.
- Under Object Instances, check on column.
- Under User Settings, check on Include owner path column for better model context.
- Press Edit, the Name field displays the column names in the model, and the owner path displays the model name and table name.
Option 2: ODBC Query Tool, you can run the following query to get a list of the columns in each table.
SELECT
TRAN(A.PHYSICAL_NAME) 'Column Name',
TRAN(E.PHYSICAL_NAME)'Table Name'
FROM
ATTRIBUTE A
JOIN ENTITY E ON
A.OWNER@ = E.ID@
TRAN(A.PHYSICAL_NAME) 'Column Name',
TRAN(E.PHYSICAL_NAME)'Table Name'
FROM
ATTRIBUTE A
JOIN ENTITY E ON
A.OWNER@ = E.ID@
Option 3: Report Designer
1. Go to Tools -> Report Designer
2. File -> Open Pinned Reports.
3. Report Categories: Model Reports-> Column Reports Physical Only Columns.erpt
4. Run report and you can export it to Excel ,HTML, or PDF.
Comments
0 comments
Please sign in to leave a comment.