Touchstone 4.0 Database Documentation
tDQAnalysisSetting Table
Stores information regarding the analysis settings used during a Data Quality analysis.
Creation Date5/31/2016 9:45 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key SettingTypeSIDUnique, system-generated sequential identifier for the group of Data Quality analysis settings record.Integer4   

Unique system-generated sequential identifier for the analysis record.

For a complete list of records, see tAnalysis Table.


Code that represents the type of output generated during the analysis.

For a complete list of codes, see tOutputType Table.

 SettingValueContains the  default setting values. For example, tenant definition ratio.VarChar8000  
 DescriptionUser-provided description of the setting value. For example, tenant policy.VarChar4000  
Objects that tDQAnalysisSetting depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tDataQualityAnalysisOption tabletDataQualityAnalysisOptionTableStores information regarding the augmentation of data during a Data Quality analysis.2
tDataQualityAnalysisOutputOption tabletDataQualityAnalysisOutputOptionTableStores the output options for a Data Quality analysis.3
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

AIRProject Database



AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.