About the Local Staging Database
In Studio, you can build projects with Data Quality activities that sort and merge data from a source system to help you cleanse and quickly migrate the data to a target system. As the Data Quality activities in a project iteratively process data from a source system--sorting "good" and "bad" data, the Integration Appliance can store the data in a Local Staging Database.
From the WMC, you can view the local database tables and lookup tables to make further changes, as needed, to the processed data. You must have the appropriate permissions to view tables and perform operations on the Local Staging Database.
Database Viewer Panes
The Database Viewer is made up of three panes:
- Database Objects pane
- Located on the left-hand side of the Database Viewer, this pane displays all tables in the Local Staging Database, including fields and rows.
- Query pane
- Located in the upper-right side of the Database Viewer, this pane
provides a workspace for you to validate and submit queries to the
Local Staging Database. You can manage each query in a separate tab.
You can perform the following operations on each tab:
Validate Query
Submit Query
Clear Query
Close Tab
- Summary pane
- Located in the lower-right side of the Database Viewer, this pane
contains two tabs: Results and History.
Results tab - Provides a summary of the rows returned from the query.
History tab - Provides a log of events that have occurred on the Local Staging Database. A time stamp marks each event logged. The log of events persists as long as the WMC is open. Once you close the WMC, the History tab is cleared.