Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing > Process of Installing the Oracle Warehouse Builder Repository >

Creating File System Locations


You must create file locations within the Oracle Warehouse Builder repository to define where the data files used in the ETL process flow are located.

This task is a step in Process of Installing the Oracle Warehouse Builder Repository.

To create a file system location

  1. Expand the Locations node in the Connection Explorer, and navigate to Files.

    On Oracle Database 11g Release 2 the Locations Node is on the Locations Navigator panel.

  2. Right-click the Files node, and click New to open the Create File System Location dialog.
  3. Enter a name and file system location, then click OK. Define the following location for your implementation. In a RAC environment, the file system location must be a shared location that all RAC nodes can access.
    Name
    Description
    Example

    DATA_FILES_LOCATION

    Where incoming data is located

    /export/home/oracle/testdata/OWF_OUTDATA

    BAD_FILE_LOCATION

    Where bad data files are written

    /export/home/oracle/testdata/bad

    DISCARD_FILE_LOCATION

    Where discarded data is written

    /export/home/oracle/testdata/discard

    LOG_FILE_LOCATION

    Where log files are written

    /export/home/oracle/testdata/log

  4. On the toolbar, click Save All to save all the changes in the Design Center.
Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.