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.

Important: The Local Staging Database must be started before you can view the Database Viewer in the WMC.

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.




Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.appliance.doc/ApplianceHelp/Local_Staging_Database/aboutLocalStagingDB.html