OWB试验手册6.docx

1、OWB试验手册6装载目标数据库一、Loading the Target Warehouse Using Process FlowsTo load data into the target dimensions and cube, you need to execute the process flow. The process flow automatically invokes the mappings to load the dimensions and the cube.To execute the process flow, perform the following steps:1.

2、From the Tools menu, select Control Center Manager. In the Control Center Manager console, expand WH_OWF_LOCATION, expand MY_PF_MODULE, and then expand PK. Select LOAD_EXPENSE_WH. To execute a process flow, you can either select Start from the File menu or click the Start ( ) button on the toolbar.

3、2.When you click the Start button, the Control Center Jobs panel switches to the Execution tab. You can monitor the execution in this panel. The executions are performed asynchronously, which means that you can close the Control Center and OWB Client while your Process Flow or Mapping is being execu

4、ted. To view the execution details, double-click LOAD_EXPENSE_WH in the Job column of the Control Center Jobs panel (highlighted in the screenshot). In the LOAD_EXPENSE_WH dialog box, click the Execution Results tab and monitor Row Activity. You can get a count of how many rows were inserted in resp

5、ective dimensions and the cube.From the File menu of the LOAD_EXPENSE_WH dialog box, select Close. From the File menu of the Control Center Manager, select Close to exit.On successful execution of the process flow, all the dimensions and the cube are now loaded with data.Viewing Data in the Data Vie

6、werYou can view the data loaded in the dimensions and the cube from within the Oracle Warehouse Builder design client environment by using the Data Viewer.1.To view REL_TIME data, expand Dimensions under EXPENSE_WH. Right-click REL_TIME and select Data.Note that the time data is based on the standar

7、d Calendar hierarchy ranging from the year 2003 for three years, as you had selected during the design of the REL_TIME dimension.2.Similarly, to view REL_CATEGORY data, right-click REL_CATEGORY and select Data. 3.To view REL_EXPENSE cube data, expand Cubes under EXPENSE_WH and right-click REL_EXPENS

8、E. Select Data.二、Managing Metadata Using the Dependency ManagerOracle Warehouse Builder provides a graphical interface that displays how changes in your sources impact the design metadata in your repository. This graphical interface is the Dependency Manager. The Dependency Manager enables you to de

9、termine the impact of the changes made to the object definitions or the metadata in the Warehouse Builder repository. These changes may occur when you reimport source metadata, when you make changes to the definitions according to end-user or external requirements, or if your target system is changi

10、ng. In all such cases where a change has been made to the metadata in your Warehouse Builder repository, the Dependency Manager helps you analyze and resolve the impact from the changes.For example, in the EXPENSE_WH scenario, all the source data is coming from the two flat files. If you want to add

11、 a column to one of the flat files, you would want to know what impact it has on the design of all the warehouse objects.You perform impact analysis for the export_csv flat file.1.Expand the OWB_DEMO project, and then expand the Files node. Expand SOURCE and right-click EXPORT_CSV. From the menu, se

12、lect Impact.Note: The interactive impact and lineage analysis is available in Enterprise ETL option of OWB 10gR2.The Metadata Dependency Manager opens. The Dependency Manager displays the initial structural impact graph for the flat file. It displays all the objects that have a structural dependency

13、 on the export_csv flat file and are, therefore, impacted by the change.From the first view of the dependency diagram, you understand that any change in the export_csv file impacts the EXPENSE_DATA external table directly and also impacts the REL_EXPENSE cube indirectly.2.The (+) sign to the left of

14、 each operator gives the dependency detail from the lineage perspective. It shows the details of all the objects that the object relies on, whereas the + sign on the right of the operator provides details of the objects that will be impacted as a result of change.For example, if you click the + sign

15、 to the left of the REL_EXPENSE cube operator in the graph, you get an expanded graph. The graph depicts that the REL_EXPENSE cube is getting inputs from the REL_CATEGORY and REL_TIME dimensions and also from the REL_EXPENSE table. The mapping symbol (the icon denotes collapsed mapping piece) also d

16、epicts that the REL_EXPENSE cube is associated with the EXPENSE_DATA external table through a mapping. 3.Double-click the icon (collapsed mapping piece) between the EXPENSE_DATA external table and the REL_EXPENSE cube to view the mapping. The collapsed mapping piece expands into REL_EXPENSE_MAP mapp

17、ing, which shows the data flow between the EXPENSE_DATA external table and the REL_EXPENSE cube.The mapping depicts that the data from the EXPENSE_DATA external table is being processed by an expression operator and loaded into the REL_EXPENSE cube. 4.To find out exactly which attributes are being p

18、rocessed by the expression operator, you can drill down to attribute level impact analysis. For attributes-level analysis, double-click the expression operator. Double-click EXPENSE_DATA and REL_EXPENSE inside the mapping box to view the input and the output attributes. The screenshot shows a portio

19、n of the dependency diagram.From the Analysis menu, select Close to exit the Dependency Manager.Therefore, the dependency diagram enabled you to easily trace and analyze the impact and lineage of a source flat file in the EXPENSE_WH scenario. 三、Administering the Warehouse Using the Repository Browse

20、rYou can use Oracle Warehouse Builder Repository Browser, an HTML-based interface, to view and generate reports on all repository metadata objects and the relationships between those objects. You can use the Repository Browser as a stand-alone component. If you want remote access to the repository m

21、etadata objects, you can use the Portal versionthe version of Warehouse Builder Repository Browser that is integrated with Oracle Application Server.After a data warehouse is functional, it needs to be administered and that involves tasks such as monitoring the details of the deployment and executio

22、n jobs. Other tasks include examining the effect of metadata changes through Impact and Lineage analysis and monitoring the execution schedules of the mappings for data refresh in the target warehouse.You now get an overview of various reports that you can view in the Repository Browser. To start th

23、e stand-alone version of the Repository Browser, you need to first start the OWB Browser Listener.1.To start the OWB Browser Listener, from your Desktop, select Start Programs your Oracle - OWB10gR2clientHome Warehouse Builder Administration Start OWB Browser Listener. A command window appears.A mes

24、sage reading .Oracle Application Server Containers for J2EE 10g (9.0.4.0.0) initialized appears in the window, as shown in the screenshot. Now, you are ready to log in to the unified repository and view the repository metadata.You only need to run one instance of OWB Browser Listener in your enterpr

25、ise. Then, anyone with the login credentials and a Web browser can access OWB Repository Reports, without the need to have OWB Client installed. Do not close the window; minimize it.2.To start the Repository Browser, from your desktop, select Start Programs your Oracle - OWB10gR2clientHome Warehouse

26、 Builder Repository Browser.A browser window with the following URL appears: http:/127.0.0.1:8999/owbb/RABLogin.uix?mode=design&def_host=&def_port=1521&def_service=&def_net_service=3.On the login page, enter the following information:Username: rep_ownerPassword: rep_ownerHost address: localhostHost

27、Port Number: 1521 (already set)Host Service Name: orcl or Click Login.The following screen appears.The Control Center reports are categorized into deployment, execution, and management reports. Before you examine the control center reports, you will examine the design repository. In Related Links, c

28、lick Design Repository: Navigator.The following screen appears:In the Navigator, you can navigate to your projects in the Unified Repository and explore the details of the objects inside the project. The rep_owner repository is shown in the table (highlighted in the screenshot by a red rectangle).4.

29、Expand rep_owner, and then expand OWB_DEMO. You will get a view of all the modules. Expand EXPENSE_WH and you get a listing of all the objects contained in the module. You can drill down further by expanding each of the object nodes. Expand EXPENSE_CATEGORIES. The columns of the external table are s

30、hown.5.If you want to browse Control Center reports, you do not need to access the login page again. To switch over to Control Center Reports, scroll down on the same page and click Control Center: Reports in the Related Links section at the bottom of the page, as shown in the screenshot.The followi

31、ng screen appears.If you want to know the current deployment status of all the objects, click the Object Summary Report link (highlighted in the screenshot) in the Deployment section of the Reports page.6.In the Object Summary Report, you see useful deployment details of each object. For example, yo

32、u get to know that REL_EXPENSE cube was deployed to EXPENSE_WH_LOCATION on 31st December 2005 at 6.28 p.m. and that the object status is valid.You can drill down further into deployment details by clicking any of the links. Scroll up on the same page and click Execution Summary in the Available Reports section at the upper-right corner, highlighted in the screens