Tutorials Oracle WarehouseWe'll follow the same steps as we did in the last chapter where we created the ACME_WS_ORDERS module. Right-click on the Oracle object under Databases and select New... from the pop-up menu to launch the Create Module Wizard and step through the process. We'll name this module ACME_DWH for ACME Data Warehouse.
TIP: An important difference between creating this module and the module we created in the last chapter is that we need to designate this one as a target module. On the Step 1 of 2 screen, be sure to select Warehouse Target as the type rather than Data Source.
Create the location in the next step, which is similar to how we created it in the last chapter, but be sure to specify the database that is our target database instead of the source we used last time. If we're creating our own test system, the source location may very well be the same as our target. But in real-world situations, it will likely be in a different database on a different server. If we had created a target user schema on a different database, this is the point at which we would be able to enter the connection information for that user in order to associate our target module with that user and make it a target.
For reference, the location screen should look like the following for defining the location of the target module:
We have specified the User Name to be the user we just created for this very purpose in the previous section.
NOTE: In this dialog box, we can see the location information (Host, Port and Service Name) that we can use to specify a user in another database if needed. If our user were not in this database, we would just enter his or her appropriate host and port for the location and the service name of that remote database.
Now that we have our target database schema and a target module defined, which is associated with a location pointing to that target schema, we will now have two Oracle modules under our Oracle object in Project Explorer. We can continue our discussion of the design objects available to us in the Warehouse Builder for designing our database. First, let's make sure we save our work so far by using the Ctrl+S key combination or by selecting Design | Save All from the main menu.
