Extracting 3rd Normal Form (3NF) Data - trillium_discovery - trillium_quality - 17.1

The Normal Form Decomposition feature is found in a Dependencies List View. You can extract 3rd Normal Form data from an entity that is not normalized. You extract by either creating an entity from a Dependencies List View or exporting the List View as a file.

To extract 3NF data

1. Open a Dependencies List View.
2. Right-click one or more dependencies and select Normal Form Decomposition.
   Note: This option is only available for multiple dependencies if the values in the Lh Attrs column are the same.
3. To extract the 3NF data, do one of the following:

   Option	Task
   Create an Entity based on information shown in List View	Right-click in List View and select Convert view to Entity…. Enter a name for the entity. If necessary, check Load data into new Entity? Checked—loads data shown into the repository and calculates data statistic Not checked—creates a dynamic entity.
   Export information shown in List View	Right-click in the List View and select either Export > All Rows/Selected Rows or Export to Server > All Rows/Selected Rows.