How to: |
This section describes how to create a text file using a DQS plan with the Data Quality Metric step.
To create a DQS plan:
If you have not installed iWay DQS, perform the following steps:
[iWayDQSHOME]\runtime\license_keys
Note: The location on your file system where the DQS archive file is extracted to is referred as [iWayDQSHOME].
[iWayDQSHOME]\workspace
iWay DQS opens, as shown in the following image.
The Create New Project dialog box is displayed.
The new project (for example, Metrics) is listed below the DQ Projects node in the File Explorer tab, as shown in the following image.
The Data_Profiling project contains the following folder structure:
Note: This standard folder structure is created by iWay DQS for easy organization. Any number of folders and subfolders can be added if required.
The Edit File Metadata dialog box opens, as shown in the following image.
Note: The input file can consist of different formats, for example, an Excel spreadsheet, various databases, and so on. For more information, see the iWay Data Quality Server Reference Guide.
The File Name field specifies the name and location of the input text file (../data/in/Airlinejan2010.txt), as shown in the following image.
The Data Quality Indicator step properties dialog box opens, as shown in the following image.
Note: Explained Column and Out Records Filter type have no effect on the summary text file that is going to be produced for iWay Data Profiler. It is related to the overall output, which is going to be discarded. You must specify those fields since it is required.
For example:
Note: Do not press Enter while entering values in the Expression and Description fields. In addition, do not use single quote (') and double quote (“) characters in the expression.
The File Name field specifies the location of the output text file (../data/out/DQIAirlineJan2010_Report.txt), which is generated by running the DQIAirlineJan2010 plan (Airlines_Quality.plan). The output file is created under the bin folder.
Note: Leave the default values for the remaining options.
Note: The out folder is located under the data folder, in the metric project folder structure.
iWay Software |