Open Studio for Data Quality
PrerequisitesA database connection is created in the Profiling perspective.
Access the actual analyzed data
To match primary and foreign keys in tables, do the following:
Through this view, you can also access the actual analyzed data via the data explorer.
|View match rows||access a list of all rows that could be matched in the two identical column sets|
|View not match rows||access a list of all rows that could not be matched in the two identical column sets|
|View rows||access a list of all rows in the two identical column sets|
The figure below illustrates in the data explorer the list of all analyzed rows in the two columns.
From the SQL editor, you can save the executed query and list it under the DQ Repository tree view if you click the save icon on the editor toolbar. For more information, see Saving the queries executed on indicators.folders in the