Documenting Table/Entity Data ETL

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Data Lineage Workflow

Use the Data Lineage tab of the entity or table editor to document how often the table/entity data is sourced and when it was last sourced. Once you have created data movement rules in the Data Lineage Explorer, you can apply these rules to the selected table/entity. You can associate as many data movement rules as you want to the table/entity. You can report data movement rules when creating reports, generating SQL or XML Schema, or Metadata is exported.

Document table data movement

  1. From the Data Model tab, navigate to and then double-click the table/entity whose data lineage you want to document.
  2. In the Table Editor, click the Data Lineage tab.
  3. Complete the Data Lineage dialog as required and then click OK to exit the editor.

See Also