About Data Quality Activities

Use the Data Quality activities in Studio to migrate or load data into a new system and/or synchronize data between existing systems.

From the Activities tab in the Studio toolbox, select the Data Quality directory. The Data Quality activities include:
  • Filter and Profile – Filters data based on the Boolean expression you create and generates a profile summary of the cleansed data.
  • Lookup – Retrieves rows of data from the database endpoint, which you select.
  • Sort – Sorts the inputs based on sort keys you specify.
  • Merge – Joins two sorted inputs.
The Integration Appliance has a Local Staging Database where you can stage the data. The Local Staging Database can be used to share data between jobs to facilitate an iterative data cleansing process.  You can view and edit data in the  Local Staging Database through the Web Management Console (WMC).
From the WMC, you can compelete the following operations against the Local Staging Database:
  • Start and Stop the database server
  • Connect to the Local Staging Database
  • Create tables
  • Drop tables
  • View tables and sort by columns
  • Add rows
  • Delete rows
For more information about performing these operations, see the WMC Online Help.



Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/aboutdataqualityactivities.html