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