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.