Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\target.db
<?xml version="1.0" encoding="UTF-8"?> <div element="book" href="toc.htm" number="" targetptr=""> <ttl>Oracle Warehouse Builder Sources and Targets Guide</ttl> <xreftext><cite> Oracle Warehouse Builder Sources and Targets Guide</cite></xreftext> <div element="chapter" href="intro_sources_targets.htm" number="1" targetptr="WBDOD10501"> <ttl>Connecting to Sources and Targets in Oracle Warehouse Builder</ttl> <xreftext>“Connecting to Sources and Targets in Oracle Warehouse Builder”</xreftext> <div element="sect1" href="wbdod04367.htm" number="1.1" targetptr="WBDOD04367"> <ttl>Supported Sources and Targets</ttl> <xreftext>“Supported Sources and Targets”</xreftext> <obj element="table" href="wbdod04367.htm" number="1-1" targetptr="WBDOD90694"> <ttl>Sources and Targets Supported in Oracle Warehouse Builder 11g Release 2 (11.2)</ttl> <xreftext>“Sources and Targets Supported in Oracle Warehouse Builder 11g Release 2 (11.2)”</xreftext> </obj> </div> <div element="sect1" href="wbdod10512.htm" number="1.2" targetptr="WBDOD10512"> <ttl>Oracle Database Heterogeneous Services</ttl> <xreftext>“Oracle Database Heterogeneous Services”</xreftext> <div element="sect2" href="wbdod10513.htm" number="1.2.1" targetptr="WBDOD10513"> <ttl>Connecting Through Oracle Database Gateways</ttl> <xreftext>“Connecting Through Oracle Database Gateways”</xreftext> </div> <div element="sect2" href="wbdod90578.htm" number="1.2.2" targetptr="WBDOD90578"> <ttl>Connecting Through JDBC</ttl> <xreftext>“Connecting Through JDBC”</xreftext> </div> <div element="sect2" href="intro_sources_targets001.htm" number="1.2.3" targetptr=""> <ttl>Choosing JDBC or Gateways Connectivity</ttl> <xreftext>“Choosing JDBC or Gateways Connectivity”</xreftext> </div> <div element="sect2" href="wbdod10514.htm" number="1.2.4" targetptr="WBDOD10514"> <ttl>Connecting Through ODBC</ttl> <xreftext>“Connecting Through ODBC”</xreftext> </div> </div> <div element="sect1" href="intro_sources_targets002.htm" number="1.3" targetptr=""> <ttl>Flexible Code Templates for Data Movement</ttl> <xreftext>“Flexible Code Templates for Data Movement”</xreftext> </div> <div element="sect1" href="wbdod10515.htm" number="1.4" targetptr="WBDOD10515"> <ttl>Connecting Through Code Templates</ttl> <xreftext>“Connecting Through Code Templates”</xreftext> </div> <div element="sect1" href="wbdod10516.htm" number="1.5" targetptr="WBDOD10516"> <ttl>Connecting Through ERP Application Connectors</ttl> <xreftext>“Connecting Through ERP Application Connectors”</xreftext> </div> <div element="sect1" href="wbdod10517.htm" number="1.6" targetptr="WBDOD10517"> <ttl>Choosing a Connection Technology</ttl> <xreftext>“Choosing a Connection Technology”</xreftext> </div> </div> <div element="chapter" href="importing_metadata.htm" number="2" targetptr="WBDOD10502"> <ttl>Connecting to Oracle Database and Other Data Sources</ttl> <xreftext>“Connecting to Oracle Database and Other Data Sources”</xreftext> <div element="sect1" href="wbdod04364.htm" number="2.1" targetptr="WBDOD04364"> <ttl>About Source Data and Metadata</ttl> <xreftext>“About Source Data and Metadata”</xreftext> </div> <div element="sect1" href="wbdod10518.htm" number="2.2" targetptr="WBDOD10518"> <ttl>General Steps for Importing Metadata from Sources</ttl> <xreftext>“General Steps for Importing Metadata from Sources”</xreftext> <obj element="bridgehead" href="wbdod10518.htm" number="" targetptr="WBDOD90696"> <ttl>Subsequent Steps</ttl> <xreftext>“Subsequent Steps”</xreftext> </obj> <div element="sect2" href="f1_pflow_wiz_connection.htm" number="2.2.1" targetptr="WBDOD04362"> <ttl>About Locations</ttl> <xreftext>“About Locations”</xreftext> <obj element="bridgehead" href="f1_pflow_wiz_connection.htm" number="" targetptr="WBDOD90697"> <ttl>Automatically Created Locations</ttl> <xreftext>“Automatically Created Locations”</xreftext> </obj> <obj element="bridgehead" href="f1_pflow_wiz_connection.htm" number="" targetptr="WBDOD90698"> <ttl>Types of Locations</ttl> <xreftext>“Types of Locations”</xreftext> </obj> <div element="sect3" href="wbdod10519.htm" number="2.2.1.1" targetptr="WBDOD10519"> <ttl>Creating Locations</ttl> <xreftext>“Creating Locations”</xreftext> <obj element="bridgehead" href="wbdod10519.htm" number="" targetptr="WBDOD90699"> <ttl>Using SQL*Net to Create Locations</ttl> <xreftext>“Using SQL*Net to Create Locations”</xreftext> </obj> <obj element="bridgehead" href="wbdod10519.htm" number="" targetptr="WBDOD90700"> <ttl>About Locations, Passwords, and Security</ttl> <xreftext>“About Locations, Passwords, and Security”</xreftext> </obj> </div> <div element="sect3" href="wbdod10520.htm" number="2.2.1.2" targetptr="WBDOD10520"> <ttl>Granting Privileges to a Target Location</ttl> <xreftext>“Granting Privileges to a Target Location”</xreftext> <obj element="bridgehead" href="wbdod10520.htm" number="" targetptr="WBDOD90701"> <ttl>Upgrade Action</ttl> <xreftext>“Upgrade Action”</xreftext> </obj> <obj element="bridgehead" href="wbdod10520.htm" number="" targetptr="WBDOD90702"> <ttl>EUL Deployment</ttl> <xreftext>“EUL Deployment”</xreftext> </obj> </div> <div element="sect3" href="wbdod10521.htm" number="2.2.1.3" targetptr="WBDOD10521"> <ttl>Registering and Unregistering Locations</ttl> <xreftext>“Registering and Unregistering Locations”</xreftext> </div> <div element="sect3" href="wbdod10522.htm" number="2.2.1.4" targetptr="WBDOD10522"> <ttl>Deleting Locations</ttl> <xreftext>“Deleting Locations”</xreftext> </div> <div element="sect3" href="wbdod10523.htm" number="2.2.1.5" targetptr="WBDOD10523"> <ttl>Locations Registered in Multiple Control Centers</ttl> <xreftext>“Locations Registered in Multiple Control Centers”</xreftext> </div> </div> <div element="sect2" href="wbdod10524.htm" number="2.2.2" targetptr="WBDOD10524"> <ttl>About DB Connectors and Directories</ttl> <xreftext>“About DB Connectors and Directories”</xreftext> </div> <div element="sect2" href="wbdod04363.htm" number="2.2.3" targetptr="WBDOD04363"> <ttl>About Modules</ttl> <xreftext>“About Modules”</xreftext> <div element="sect3" href="wbdod10525.htm" number="2.2.3.1" targetptr="WBDOD10525"> <ttl>Creating Modules</ttl> <xreftext>“Creating Modules”</xreftext> </div> <div element="sect3" href="wbdod10526.htm" number="2.2.3.2" targetptr="WBDOD10526"> <ttl>Creating User-Defined Folders</ttl> <xreftext>“Creating User-Defined Folders”</xreftext> </div> </div> </div> <div element="sect1" href="translate_21.htm" number="2.3" targetptr="WBDOD04370"> <ttl>Using the Import Metadata Wizard</ttl> <xreftext>“Using the Import Metadata Wizard”</xreftext> </div> <div element="sect1" href="wbdod10527.htm" number="2.4" targetptr="WBDOD10527"> <ttl>Importing Metadata Definitions from Oracle Database</ttl> <xreftext>“Importing Metadata Definitions from Oracle Database”</xreftext> <div element="sect2" href="importing_metadata001.htm" number="2.4.1" targetptr="BABFJEAI"> <ttl>Edit Oracle Database Location Dialog Box</ttl> <xreftext>“Edit Oracle Database Location Dialog Box”</xreftext> <obj element="bridgehead" href="importing_metadata001.htm" number="" targetptr=""> <ttl>Name</ttl> <xreftext>“Name”</xreftext> </obj> <obj element="bridgehead" href="importing_metadata001.htm" number="" targetptr=""> <ttl>Description</ttl> <xreftext>“Description”</xreftext> </obj> <obj element="bridgehead" href="importing_metadata001.htm" number="" targetptr=""> <ttl>Type</ttl> <xreftext>“Type”</xreftext> </obj> <obj element="bridgehead" href="importing_metadata001.htm" number="" targetptr=""> <ttl>Schema</ttl> <xreftext>“Schema”</xreftext> </obj> <obj element="bridgehead" href="importing_metadata001.htm" number="" targetptr=""> <ttl>Version</ttl> <xreftext>“Version”</xreftext> </obj> <obj element="bridgehead" href="importing_metadata001.htm" number="" targetptr=""> <ttl>Test Connection</ttl> <xreftext>“Test Connection”</xreftext> </obj> <obj element="bridgehead" href="importing_metadata001.htm" number="" targetptr=""> <ttl>Test Results</ttl> <xreftext>“Test Results”</xreftext> </obj> </div> <div element="sect2" href="importing_metadata002.htm" number="2.4.2" targetptr=""> <ttl>Importing Metadata Definitions</ttl> <xreftext>“Importing Metadata Definitions”</xreftext> </div> <div element="sect2" href="f1_import_wiz_filter_oracle.htm" number="2.4.3" targetptr="WBDOD10528"> <ttl>Filter Information Page</ttl> <xreftext>“Filter Information Page”</xreftext> <obj element="bridgehead" href="f1_import_wiz_filter_oracle.htm" number="" targetptr="WBDOD90704"> <ttl>Selecting the Object Types</ttl> <xreftext>“Selecting the Object Types”</xreftext> </obj> <obj element="bridgehead" href="f1_import_wiz_filter_oracle.htm" number="" targetptr="WBDOD90705"> <ttl>Search Based on the Object Name</ttl> <xreftext>“Search Based on the Object Name”</xreftext> </obj> </div> <div element="sect2" href="f1_import_wiz_object_select.htm" number="2.4.4" targetptr="WBDOD10529"> <ttl>Object Selection Page</ttl> <xreftext>“Object Selection Page”</xreftext> <obj element="bridgehead" href="f1_import_wiz_object_select.htm" number="" targetptr="WBDOD90706"> <ttl>Importing Dependent Objects</ttl> <xreftext>“Importing Dependent Objects”</xreftext> </obj> <obj element="bridgehead" href="f1_import_wiz_object_select.htm" number="" targetptr="WBDOD90707"> <ttl>Importing Dimensions</ttl> <xreftext>“Importing Dimensions”</xreftext> </obj> </div> <div element="sect2" href="wbdod10530.htm" number="2.4.5" targetptr="WBDOD10530"> <ttl>Summary and Import Page</ttl> <xreftext>“Summary and Import Page”</xreftext> </div> <div element="sect2" href="f1_import_results_dialog.htm" number="2.4.6" targetptr="WBDOD10531"> <ttl>Import Results Page</ttl> <xreftext>“Import Results Page”</xreftext> </div> </div> <div element="sect1" href="f1_imp_preview_dlg.htm" number="2.5" targetptr="WBDOD10532"> <ttl>Reimporting Definitions</ttl> <xreftext>“Reimporting Definitions”</xreftext> <div element="sect2" href="f1_adv_reconcile_dialog.htm" number="2.5.1" targetptr="WBDOD10533"> <ttl>Advanced Import Options</ttl> <xreftext>“Advanced Import Options”</xreftext> <div element="sect3" href="wbdod10534.htm" number="2.5.1.1" targetptr="WBDOD10534"> <ttl>Advanced Import Options for Views and External Tables</ttl> <xreftext>“Advanced Import Options for Views and External Tables”</xreftext> </div> <div element="sect3" href="wbdod10535.htm" number="2.5.1.2" targetptr="WBDOD10535"> <ttl>Advanced Import Options for Tables</ttl> <xreftext>“Advanced Import Options for Tables”</xreftext> </div> <div element="sect3" href="wbdod10536.htm" number="2.5.1.3" targetptr="WBDOD10536"> <ttl>Advanced Import Options for Object Types</ttl> <xreftext>“Advanced Import Options for Object Types”</xreftext> </div> </div> <div element="sect2" href="wbdod10538.htm" number="2.5.2" targetptr="WBDOD10538"> <ttl>Updating Source Module Definitions</ttl> <xreftext>“Updating Source Module Definitions”</xreftext> </div> </div> </div> <div element="chapter" href="defining_flatfiles.htm" number="3" targetptr="WBDOD10503"> <ttl>Using Flat Files as Sources or Targets</ttl> <xreftext>“<span class="italic"></span> Using Flat Files as Sources or Targets”</xreftext> <div element="sect1" href="wbdod10539.htm" number="3.1" targetptr="WBDOD10539"> <ttl>About Flat Files</ttl> <xreftext>“About Flat Files”</xreftext> <div element="sect2" href="defining_flatfiles001.htm" number="3.1.1" targetptr=""> <ttl>About Metadata for Flat Files</ttl> <xreftext>“About Metadata for Flat Files”</xreftext> </div> <div element="sect2" href="defining_flatfiles002.htm" number="3.1.2" targetptr=""> <ttl>About Flat File Modules and Locations</ttl> <xreftext>“About Flat File Modules and Locations”</xreftext> </div> <div element="sect2" href="defining_flatfiles003.htm" number="3.1.3" targetptr=""> <ttl>Working with Flat Files as Sources or Targets</ttl> <xreftext>“Working with Flat Files as Sources or Targets”</xreftext> </div> <div element="sect2" href="defining_flatfiles004.htm" number="3.1.4" targetptr=""> <ttl>Flat Files as Sources</ttl> <xreftext>“Flat Files as Sources”</xreftext> <div element="sect3" href="defining_flatfiles005.htm" number="3.1.4.1" targetptr="BABDEJDJ"> <ttl>Defining Character Data Files</ttl> <xreftext>“Defining Character Data Files”</xreftext> </div> <div element="sect3" href="defining_flatfiles006.htm" number="3.1.4.2" targetptr=""> <ttl>About External Tables</ttl> <xreftext>“About External Tables”</xreftext> </div> <div element="sect3" href="defining_flatfiles007.htm" number="3.1.4.3" targetptr="BABJEBEH"> <ttl>Choosing Between External Table and Flat File Operators</ttl> <xreftext>“Choosing Between External Table and Flat File Operators”</xreftext> </div> </div> <div element="sect2" href="wbdod10545.htm" number="3.1.5" targetptr="WBDOD10545"> <ttl>Flat Files as Targets</ttl> <xreftext>“Flat Files as Targets”</xreftext> <obj element="bridgehead" href="wbdod10545.htm" number="" targetptr="WBDOD90708"> <ttl>Creating a New Flat File as a Target</ttl> <xreftext>“Creating a New Flat File as a Target”</xreftext> </obj> </div> <div element="sect2" href="f1_logical_location_dialog.htm" number="3.1.6" targetptr="WBDOD10546"> <ttl>Creating Flat File Modules</ttl> <xreftext>“Creating Flat File Modules”</xreftext> <div element="sect3" href="wbdod10547.htm" number="3.1.6.1" targetptr="WBDOD10547"> <ttl>Describing the Flat File Module</ttl> <xreftext>“Describing the Flat File Module”</xreftext> </div> <div element="sect3" href="f1_loc_file.htm" number="3.1.6.2" targetptr="WBDOD10548"> <ttl>Defining Locations for Flat File Modules</ttl> <xreftext>“Defining Locations for Flat File Modules”</xreftext> </div> <div element="sect3" href="wbdod10549.htm" number="3.1.6.3" targetptr="WBDOD10549"> <ttl>Connection Information Page</ttl> <xreftext>“Connection Information Page”</xreftext> </div> <div element="sect3" href="wbdod10550.htm" number="3.1.6.4" targetptr="WBDOD10550"> <ttl>Edit File System Location Dialog Box</ttl> <xreftext>“Edit File System Location Dialog Box”</xreftext> </div> </div> </div> <div element="sect1" href="f1_file_wiz_welcome.htm" number="3.2" targetptr="WBDOD10551"> <ttl>Using the Create Flat File Wizard</ttl> <xreftext>“Using the Create Flat File Wizard”</xreftext> <div element="sect2" href="f1_file_wiz_name.htm" number="3.2.1" targetptr="WBDOD10552"> <ttl>Describing a Flat File</ttl> <xreftext>“Describing a Flat File”</xreftext> </div> <div element="sect2" href="f1_file_wiz_general_fixed.htm" number="3.2.2" targetptr="WBDOD10553"> <ttl>Defining File Properties for a Flat File</ttl> <xreftext>“Defining File Properties for a Flat File”</xreftext> <div element="sect3" href="wbdod10554.htm" number="3.2.2.1" targetptr="WBDOD10554"> <ttl>Record Organization</ttl> <xreftext>“Record Organization”</xreftext> </div> <div element="sect3" href="wbdod10555.htm" number="3.2.2.2" targetptr="WBDOD10555"> <ttl>Logical Record Definition</ttl> <xreftext>“Logical Record Definition<span class="bold"></span>”</xreftext> </div> <div element="sect3" href="wbdod10556.htm" number="3.2.2.3" targetptr="WBDOD10556"> <ttl>Number of Rows to Skip</ttl> <xreftext>“Number of Rows to Skip”</xreftext> </div> <div element="sect3" href="wbdod10557.htm" number="3.2.2.4" targetptr="WBDOD10557"> <ttl>Field Format</ttl> <xreftext>“Field Format”</xreftext> </div> </div> <div element="sect2" href="f1_file_wiz_record.htm" number="3.2.3" targetptr="WBDOD10558"> <ttl>Defining the Record Type for a Flat File</ttl> <xreftext>“Defining the Record Type for a Flat File”</xreftext> </div> <div element="sect2" href="f1_file_wiz_structure.htm" number="3.2.4" targetptr="WBDOD10559"> <ttl>Defining Field Properties for a Flat File</ttl> <xreftext>“Defining Field Properties for a Flat File”</xreftext> <div element="sect3" href="wbdod10560.htm" number="3.2.4.1" targetptr="WBDOD10560"> <ttl>SQL*Loader Properties</ttl> <xreftext>“SQL*Loader Properties”</xreftext> <obj element="bridgehead" href="wbdod10560.htm" number="" targetptr="WBDOD90709"> <ttl>Type</ttl> <xreftext>“Type”</xreftext> </obj> <obj element="bridgehead" href="wbdod10560.htm" number="" targetptr="WBDOD90710"> <ttl>Length</ttl> <xreftext>“Length”</xreftext> </obj> <obj element="bridgehead" href="wbdod10560.htm" number="" targetptr="WBDOD90711"> <ttl>Precision</ttl> <xreftext>“Precision”</xreftext> </obj> <obj element="bridgehead" href="wbdod10560.htm" number="" targetptr="WBDOD90712"> <ttl>Scale</ttl> <xreftext>“Scale”</xreftext> </obj> <obj element="bridgehead" href="wbdod10560.htm" number="" targetptr="WBDOD90713"> <ttl>Mask</ttl> <xreftext>“Mask”</xreftext> </obj> <obj element="bridgehead" href="wbdod10560.htm" number="" targetptr="WBDOD90714"> <ttl>NULLIF</ttl> <xreftext>“NULLIF”</xreftext> </obj> <obj element="bridgehead" href="wbdod10560.htm" number="" targetptr="WBDOD90715"> <ttl>DEFAULTIF</ttl> <xreftext>“DEFAULTIF”</xreftext> </obj> </div> <div element="sect3" href="wbdod10561.htm" number="3.2.4.2" targetptr="WBDOD10561"> <ttl>SQL Properties</ttl> <xreftext>“SQL Properties”</xreftext> <obj element="bridgehead" href="wbdod10561.htm" number="" targetptr="WBDOD90716"> <ttl>SQL Type</ttl> <xreftext>“SQL Type”</xreftext> </obj> <obj element="bridgehead" href="wbdod10561.htm" number="" targetptr="WBDOD90717"> <ttl>SQL Length</ttl> <xreftext>“SQL Length”</xreftext> </obj> <obj element="bridgehead" href="wbdod10561.htm" number="" targetptr="WBDOD90718"> <ttl>SQL Precision</ttl> <xreftext>“SQL Precision”</xreftext> </obj> <obj element="bridgehead" href="wbdod10561.htm" number="" targetptr="WBDOD90719"> <ttl>SQL Scale</ttl> <xreftext>“SQL Scale”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="f1_import_wiz_filter_flatfile.htm" number="3.3" targetptr="WBDOD10562"> <ttl>Importing Definitions from Flat Files Using Sampling</ttl> <xreftext>“Importing Definitions from Flat Files Using Sampling”</xreftext> <div element="sect2" href="f1_flatfile_welcome.htm" number="3.3.1" targetptr="WBDOD10563"> <ttl>Using the Flat File Sample Wizard</ttl> <xreftext>“Using the Flat File Sample Wizard”</xreftext> <div element="sect3" href="wbdod90579.htm" number="3.3.1.1" targetptr="WBDOD90579"> <ttl>Flat File Wizard for Simple Flat Files</ttl> <xreftext>“Flat File Wizard for Simple Flat Files”</xreftext> </div> <div element="sect3" href="f1_flatfile_name.htm" number="3.3.1.2" targetptr="WBDOD10564"> <ttl>Describing the Flat File</ttl> <xreftext>“Describing the Flat File”</xreftext> </div> <div element="sect3" href="wbdod90580.htm" number="3.3.1.3" targetptr="WBDOD90580"> <ttl>Specifying the Record Organization</ttl> <xreftext>“Specifying the Record Organization”</xreftext> </div> <div element="sect3" href="wbdod90575.htm" number="3.3.1.4" targetptr="WBDOD90575"> <ttl>Specifying Field Properties</ttl> <xreftext>“Specifying Field Properties”</xreftext> <div element="sect4" href="wbdod10576.htm" number="3.3.1.4.1" targetptr="WBDOD10576"> <ttl>SQL*Loader Properties</ttl> <xreftext>“SQL*Loader Properties”</xreftext> </div> <div element="sect4" href="wbdod10577.htm" number="3.3.1.4.2" targetptr="WBDOD10577"> <ttl>SQL Properties</ttl> <xreftext>“SQL Properties”</xreftext> </div> </div> <div element="sect3" href="wbdod90581.htm" number="3.3.1.5" targetptr="WBDOD90581"> <ttl>Flat File Wizard For Complex Flat Files</ttl> <xreftext>“Flat File Wizard For Complex Flat Files”</xreftext> </div> <div element="sect3" href="wbdod90564.htm" number="3.3.1.6" targetptr="WBDOD90564"> <ttl>Describing the Flat File</ttl> <xreftext>“Describing the Flat File”</xreftext> </div> <div element="sect3" href="f1_flatfile_fixed_mult_recorg.htm" number="3.3.1.7" targetptr="WBDOD10565"> <ttl>Selecting the Record Organization</ttl> <xreftext>“Selecting the Record Organization”</xreftext> <div element="sect4" href="wbdod10566.htm" number="3.3.1.7.1" targetptr="WBDOD10566"> <ttl>Specifying Logical Records</ttl> <xreftext>“Specifying Logical Records<span class="bold"></span>”</xreftext> </div> </div> <div element="sect3" href="f1_flatfile_setup.htm" number="3.3.1.8" targetptr="WBDOD10567"> <ttl>Selecting the File Format</ttl> <xreftext>“Selecting the File Format”</xreftext> </div> <div element="sect3" href="f1_flatfile_recorg.htm" number="3.3.1.9" targetptr="WBDOD10568"> <ttl>Selecting the File Layout</ttl> <xreftext>“Selecting the File Layout”</xreftext> </div> <div element="sect3" href="wbdod10569.htm" number="3.3.1.10" targetptr="WBDOD10569"> <ttl>Selecting Record Types (Multiple Record Type Files Only)</ttl> <xreftext>“Selecting Record Types (Multiple Record Type Files Only)”</xreftext> <div element="sect4" href="wbdod10570.htm" number="3.3.1.10.1" targetptr="WBDOD10570"> <ttl>Example: Flat File with Multiple Record Types</ttl> <xreftext>“Example: Flat File with Multiple Record Types”</xreftext> <obj element="figure" href="wbdod10570.htm" number="3-1" targetptr="WBDOD90720"> <ttl>Example of a File with Multiple Record Types</ttl> <xreftext>“Example of a File with Multiple Record Types”</xreftext> </obj> </div> <div element="sect4" href="f1_flatfile_delim_mult_rectype.htm" number="3.3.1.10.2" targetptr="WBDOD10571"> <ttl>Defining Multiple Record Organization in a Delimited File</ttl> <xreftext>“Defining Multiple Record Organization in a Delimited File”</xreftext> </div> <div element="sect4" href="f1_flatfile_fixed_mult_rectype.htm" number="3.3.1.10.3" targetptr="WBDOD10572"> <ttl>Defining Multiple Record Organization in a Fixed-Length File</ttl> <xreftext>“Defining Multiple Record Organization in a Fixed-Length File”</xreftext> </div> </div> <div element="sect3" href="f1_flatfile_single_col.htm" number="3.3.1.11" targetptr="WBDOD10573"> <ttl>Specifying Field Lengths (Fixed-Length Files Only)</ttl> <xreftext>“Specifying Field Lengths (Fixed-Length Files Only)”</xreftext> <div element="sect4" href="f1_flatfile_fixed_mult_col.htm" number="3.3.1.11.1" targetptr="WBDOD10574"> <ttl>Specifying Field Lengths for Multiple Record Files</ttl> <xreftext>“Specifying Field Lengths for Multiple Record Files”</xreftext> </div> </div> <div element="sect3" href="f1_flatfile_delim_single_prop.htm" number="3.3.1.12" targetptr="WBDOD10575"> <ttl>Specifying Field Properties</ttl> <xreftext>“Specifying Field Properties”</xreftext> <div element="sect4" href="wbdod90576.htm" number="3.3.1.12.1" targetptr="WBDOD90576"> <ttl>SQL*Loader Properties</ttl> <xreftext>“SQL*Loader Properties”</xreftext> </div> <div element="sect4" href="wbdod90577.htm" number="3.3.1.12.2" targetptr="WBDOD90577"> <ttl>SQL Properties</ttl> <xreftext>“SQL Properties”</xreftext> </div> </div> </div> </div> <div element="sect1" href="defining_flatfiles008.htm" number="3.4" targetptr="BABGGBJG"> <ttl>Importing Data from COBOL Copybooks</ttl> <xreftext>“Importing Data from COBOL Copybooks”</xreftext> <div element="sect2" href="defining_flatfiles009.htm" number="3.4.1" targetptr=""> <ttl>Understanding Data Hierarchy in COBOL Applications</ttl> <xreftext>“Understanding Data Hierarchy in COBOL Applications”</xreftext> <obj element="example" href="defining_flatfiles009.htm" number="3-1" targetptr="BABFHDAG"> <ttl>COBOL Copybook</ttl> <xreftext>“COBOL Copybook”</xreftext> </obj> <div element="sect3" href="defining_flatfiles010.htm" number="3.4.1.1" targetptr=""> <ttl>COBOL Data Types</ttl> <xreftext>“COBOL Data Types”</xreftext> </div> <div element="sect3" href="defining_flatfiles011.htm" number="3.4.1.2" targetptr=""> <ttl>Arrays Defined on Fields</ttl> <xreftext>“Arrays Defined on Fields”</xreftext> <obj element="example" href="defining_flatfiles011.htm" number="3-2" targetptr="BABGBFGI"> <ttl>Arrays Defined on Elementary Fields</ttl> <xreftext>“Arrays Defined on Elementary Fields”</xreftext> </obj> <obj element="example" href="defining_flatfiles011.htm" number="3-3" targetptr="BABIAEDJ"> <ttl>Varying Array Defined on Elementary Fields</ttl> <xreftext>“Varying Array Defined on Elementary Fields”</xreftext> </obj> <obj element="example" href="defining_flatfiles011.htm" number="3-4" targetptr="BABEDCJD"> <ttl>Array Defined on a Group Field</ttl> <xreftext>“Array Defined on a Group Field”</xreftext> </obj> <obj element="example" href="defining_flatfiles011.htm" number="3-5" targetptr="BABHAABB"> <ttl>Varying Array Defined on a Group Field</ttl> <xreftext>“Varying Array Defined on a Group Field”</xreftext> </obj> </div> </div> <div element="sect2" href="defining_flatfiles012.htm" number="3.4.2" targetptr=""> <ttl>Multiple Definitions</ttl> <xreftext>“Multiple Definitions”</xreftext> <div element="sect3" href="defining_flatfiles013.htm" number="3.4.2.1" targetptr=""> <ttl>Multiple Record Definitions</ttl> <xreftext>“Multiple Record Definitions”</xreftext> <obj element="example" href="defining_flatfiles013.htm" number="3-6" targetptr=""> <ttl>Copybook With Multiple Records</ttl> <xreftext>“Copybook With Multiple Records”</xreftext> </obj> </div> <div element="sect3" href="defining_flatfiles014.htm" number="3.4.2.2" targetptr=""> <ttl>Group Fields</ttl> <xreftext>“Group Fields”</xreftext> </div> <div element="sect3" href="defining_flatfiles015.htm" number="3.4.2.3" targetptr=""> <ttl>Redefinition</ttl> <xreftext>“Redefinition”</xreftext> <obj element="example" href="defining_flatfiles015.htm" number="3-7" targetptr=""> <ttl>Redefining a Field</ttl> <xreftext>“Redefining a Field”</xreftext> </obj> <obj element="example" href="defining_flatfiles015.htm" number="3-8" targetptr=""> <ttl>Redefining a Group</ttl> <xreftext>“Redefining a Group”</xreftext> </obj> </div> <div element="sect3" href="defining_flatfiles016.htm" number="3.4.2.4" targetptr=""> <ttl>COBOL File Formats</ttl> <xreftext>“COBOL File Formats”</xreftext> </div> </div> <div element="sect2" href="defining_flatfiles017.htm" number="3.4.3" targetptr=""> <ttl>Reinterpreting COBOL Data Structures Into Relational Data Structures</ttl> <xreftext>“Reinterpreting COBOL Data Structures Into Relational Data Structures”</xreftext> <obj element="bridgehead" href="defining_flatfiles017.htm" number="" targetptr=""> <ttl>Records</ttl> <xreftext>“Records”</xreftext> </obj> <obj element="bridgehead" href="defining_flatfiles017.htm" number="" targetptr=""> <ttl>Arrays</ttl> <xreftext>“Arrays”</xreftext> </obj> <obj element="bridgehead" href="defining_flatfiles017.htm" number="" targetptr=""> <ttl>Mapping COBOL Data Types to SQL Data Types</ttl> <xreftext>“Mapping COBOL Data Types to SQL Data Types”</xreftext> </obj> <obj element="table" href="defining_flatfiles017.htm" number="3-1" targetptr=""> <ttl>COBOL Data Types and the Equivalent SQL *Loader Data Types</ttl> <xreftext>“COBOL Data Types and the Equivalent SQL *Loader Data Types”</xreftext> </obj> </div> <div element="sect2" href="defining_flatfiles018.htm" number="3.4.4" targetptr=""> <ttl>Importing Metadata</ttl> <xreftext>“Importing Metadata”</xreftext> <obj element="bridgehead" href="defining_flatfiles018.htm" number="" targetptr="BABIBDBC"> <ttl>Importing a Copybook</ttl> <xreftext>“Importing a Copybook”</xreftext> </obj> <div element="sect3" href="f1_imp_cob_sess_opts.htm" number="3.4.4.1" targetptr="imp_cob_sess_opts"> <ttl>Import Cobol Session Options</ttl> <xreftext>“Import Cobol Session Options”</xreftext> </div> </div> <div element="sect2" href="defining_flatfiles019.htm" number="3.4.5" targetptr="BABDAAHF"> <ttl>Example: Importing a Single Record Type Varying Array Copybook</ttl> <xreftext>“Example: Importing a Single Record Type Varying Array Copybook”</xreftext> <div element="sect3" href="defining_flatfiles020.htm" number="3.4.5.1" targetptr=""> <ttl>Importing The COBOL Copybook</ttl> <xreftext>“Importing The COBOL Copybook”</xreftext> </div> <div element="sect3" href="defining_flatfiles021.htm" number="3.4.5.2" targetptr="BABHDGGC"> <ttl>Defining the File Properties</ttl> <xreftext>“Defining the File Properties”</xreftext> </div> <div element="sect3" href="defining_flatfiles022.htm" number="3.4.5.3" targetptr=""> <ttl>Creating a Mapping to Load Data</ttl> <xreftext>“Creating a Mapping to Load Data”</xreftext> </div> <div element="sect3" href="defining_flatfiles023.htm" number="3.4.5.4" targetptr=""> <ttl>Configuring The Mapping</ttl> <xreftext>“Configuring The Mapping”</xreftext> </div> <div element="sect3" href="defining_flatfiles024.htm" number="3.4.5.5" targetptr=""> <ttl>Specifying the Data File</ttl> <xreftext>“Specifying the Data File”</xreftext> </div> </div> </div> <div element="sect1" href="wbdod10578.htm" number="3.5" targetptr="WBDOD10578"> <ttl>Viewing and Editing a File Definition</ttl> <xreftext>“Viewing and Editing a File Definition”</xreftext> <div element="sect2" href="f1_file_ps_name.htm" number="3.5.1" targetptr="WBDOD10579"> <ttl>Name Tab</ttl> <xreftext>“Name Tab”</xreftext> </div> <div element="sect2" href="f1_file_ps_general_fixed_tab.htm" number="3.5.2" targetptr="WBDOD10580"> <ttl>General Tab</ttl> <xreftext>“General Tab”</xreftext> </div> <div element="sect2" href="f1_file_ps_record.htm" number="3.5.3" targetptr="WBDOD10581"> <ttl>Record Tab</ttl> <xreftext>“Record Tab”</xreftext> <obj element="table" href="f1_file_ps_record.htm" number="3-2" targetptr="WBDOD90721"> <ttl>Example of Record Type Values</ttl> <xreftext>“Example of Record Type Values”</xreftext> </obj> </div> <div element="sect2" href="f1_file_ps_structure.htm" number="3.5.4" targetptr="WBDOD10582"> <ttl>Structure Tab</ttl> <xreftext>“Structure Tab”</xreftext> </div> </div> <div element="sect1" href="wbdod10583.htm" number="3.6" targetptr="WBDOD10583"> <ttl>Using External Tables</ttl> <xreftext>“Using External Tables”</xreftext> <div element="sect2" href="wbdod10584.htm" number="3.6.1" targetptr="WBDOD10584"> <ttl>Creating a New External Table Definition</ttl> <xreftext>“Creating a New External Table Definition”</xreftext> <obj element="bridgehead" href="wbdod10584.htm" number="" targetptr="WBDOD90722"> <ttl>Before you begin</ttl> <xreftext>“Before you begin”</xreftext> </obj> <div element="sect3" href="wbdod10585.htm" number="3.6.1.1" targetptr="WBDOD10585"> <ttl>Name Page</ttl> <xreftext>“Name Page”</xreftext> </div> <div element="sect3" href="f1_extable_fileselect.htm" number="3.6.1.2" targetptr="WBDOD10586"> <ttl>File Selection Page</ttl> <xreftext>“File Selection Page”</xreftext> </div> <div element="sect3" href="f1_extable_location.htm" number="3.6.1.3" targetptr="WBDOD10587"> <ttl>Locations Page</ttl> <xreftext>“Locations Page”</xreftext> </div> </div> <div element="sect2" href="wbdod90723.htm" number="3.6.2" targetptr="WBDOD90723"> <ttl>Importing an External Table</ttl> <xreftext>“Importing an External Table”</xreftext> </div> <div element="sect2" href="wbdod10589.htm" number="3.6.3" targetptr="WBDOD10589"> <ttl>Editing External Table Definitions</ttl> <xreftext>“Editing External Table Definitions”</xreftext> <div element="sect3" href="wbdod10590.htm" number="3.6.3.1" targetptr="WBDOD10590"> <ttl>Name Tab</ttl> <xreftext>“Name Tab”</xreftext> </div> <div element="sect3" href="f1_extable_ps_column.htm" number="3.6.3.2" targetptr="WBDOD10591"> <ttl>Columns Tab</ttl> <xreftext>“Columns Tab”</xreftext> </div> <div element="sect3" href="f1_extable_ps_file.htm" number="3.6.3.3" targetptr="WBDOD10592"> <ttl>File Tab</ttl> <xreftext>“File Tab”</xreftext> </div> <div element="sect3" href="f1_extable_ps_location.htm" number="3.6.3.4" targetptr="WBDOD10593"> <ttl>Locations Tab</ttl> <xreftext>“Locations Tab”</xreftext> </div> <div element="sect3" href="f1_extable_ps_data_rule.htm" number="3.6.3.5" targetptr="WBDOD10594"> <ttl>Data Rules Tab</ttl> <xreftext>“Data Rules Tab”</xreftext> </div> <div element="sect3" href="f1_extable_ps_accessparameter.htm" number="3.6.3.6" targetptr="WBDOD10595"> <ttl>Access Parameters Tab</ttl> <xreftext>“Access Parameters Tab”</xreftext> </div> </div> <div element="sect2" href="wbdod10588.htm" number="3.6.4" targetptr="WBDOD10588"> <ttl>Synchronizing an External Table Definition with a Record in a File</ttl> <xreftext>“Synchronizing an External Table Definition with a Record in a File”</xreftext> </div> <div element="sect2" href="wbdod10596.htm" number="3.6.5" targetptr="WBDOD10596"> <ttl>Configuring External Tables</ttl> <xreftext>“Configuring External Tables”</xreftext> <div element="sect3" href="wbdod10597.htm" number="3.6.5.1" targetptr="WBDOD10597"> <ttl>Access Specification</ttl> <xreftext>“Access Specification”</xreftext> </div> <div element="sect3" href="wbdod10598.htm" number="3.6.5.2" targetptr="WBDOD10598"> <ttl>Reject</ttl> <xreftext>“Reject”</xreftext> </div> <div element="sect3" href="wbdod10599.htm" number="3.6.5.3" targetptr="WBDOD10599"> <ttl>Parallel</ttl> <xreftext>“Parallel”</xreftext> </div> <div element="sect3" href="wbdod10600.htm" number="3.6.5.4" targetptr="WBDOD10600"> <ttl>Data Characteristics</ttl> <xreftext>“Data Characteristics”</xreftext> </div> <div element="sect3" href="wbdod10601.htm" number="3.6.5.5" targetptr="WBDOD10601"> <ttl>Field Editing</ttl> <xreftext>“Field Editing”</xreftext> </div> <div element="sect3" href="wbdod10602.htm" number="3.6.5.6" targetptr="WBDOD10602"> <ttl>Identification</ttl> <xreftext>“Identification”</xreftext> </div> <div element="sect3" href="wbdod10603.htm" number="3.6.5.7" targetptr="WBDOD10603"> <ttl>Data Files</ttl> <xreftext>“Data Files”</xreftext> </div> </div> </div> </div> <div element="chapter" href="gateways_connection.htm" number="4" targetptr="WBDOD90597"> <ttl>Connecting to non-Oracle Data Sources Through Gateways</ttl> <xreftext>“Connecting to non-Oracle Data Sources Through Gateways”</xreftext> <div element="sect1" href="wbdod90598.htm" number="4.1" targetptr="WBDOD90598"> <ttl>Connecting to a DB2 Database</ttl> <xreftext>“Connecting to a DB2 Database”</xreftext> <div element="sect2" href="wbdod90599.htm" number="4.1.1" targetptr="WBDOD90599"> <ttl>Creating a DB2 Module</ttl> <xreftext>“Creating a DB2 Module”</xreftext> </div> </div> <div element="sect1" href="wbdod90601.htm" number="4.2" targetptr="WBDOD90601"> <ttl>Connecting to a SQL Server Database</ttl> <xreftext>“Connecting to a SQL Server Database”</xreftext> <div element="sect2" href="wbdod90602.htm" number="4.2.1" targetptr="WBDOD90602"> <ttl>Creating a SQL Server Module</ttl> <xreftext>“Creating a SQL Server Module”</xreftext> </div> </div> <div element="sect1" href="wbdod90604.htm" number="4.3" targetptr="WBDOD90604"> <ttl>Connecting to an ODBC Data Source</ttl> <xreftext>“Connecting to an ODBC Data Source”</xreftext> <div element="sect2" href="wbdod90605.htm" number="4.3.1" targetptr="WBDOD90605"> <ttl>Setting up ODBC Connectivity</ttl> <xreftext>“Setting up ODBC Connectivity”</xreftext> <div element="sect3" href="wbdod90606.htm" number="4.3.1.1" targetptr="WBDOD90606"> <ttl>Installing ODBC Driver</ttl> <xreftext>“Installing ODBC Driver”</xreftext> </div> <div element="sect3" href="wbdod90607.htm" number="4.3.1.2" targetptr="WBDOD90607"> <ttl>Creating a System DSN</ttl> <xreftext>“Creating a System DSN”</xreftext> </div> <div element="sect3" href="wbdod90608.htm" number="4.3.1.3" targetptr="WBDOD90608"> <ttl>Configuring the Database</ttl> <xreftext>“Configuring the Database”</xreftext> <obj element="bridgehead" href="wbdod90608.htm" number="" targetptr="WBDOD90739"> <ttl>Creating a Heterogeneous Services Initialization File</ttl> <xreftext>“Creating a Heterogeneous Services Initialization File”</xreftext> </obj> <obj element="bridgehead" href="wbdod90608.htm" number="" targetptr="WBDOD90740"> <ttl>Configuring the listener.ora file</ttl> <xreftext>“Configuring the listener.ora file”</xreftext> </obj> </div> </div> <div element="sect2" href="wbdod90609.htm" number="4.3.2" targetptr="WBDOD90609"> <ttl>Creating an ODBC Module</ttl> <xreftext>“Creating an ODBC Module”</xreftext> </div> </div> <div element="sect1" href="wbdod90610.htm" number="4.4" targetptr="WBDOD90610"> <ttl>Importing Database Objects</ttl> <xreftext>“Importing Database Objects”</xreftext> </div> </div> <div element="chapter" href="loading_ms_data.htm" number="5" targetptr="WBDOD10508"> <ttl>Connecting to Microsoft Data Sources Through ODBC Connection</ttl> <xreftext>“Connecting to Microsoft Data Sources Through ODBC Connection”</xreftext> <div element="sect1" href="wbdod10658.htm" number="5.1" targetptr="WBDOD10658"> <ttl>Connecting to Excel Spreadsheets Through ODBC</ttl> <xreftext>“Connecting to Excel Spreadsheets Through ODBC”</xreftext> <obj element="bridgehead" href="wbdod10658.htm" number="" targetptr="WBDOD90741"> <ttl>Scenario</ttl> <xreftext>“Scenario”</xreftext> </obj> <obj element="bridgehead" href="wbdod10658.htm" number="" targetptr="WBDOD90742"> <ttl>Solution</ttl> <xreftext>“Solution”</xreftext> </obj> <div element="sect2" href="wbdod10659.htm" number="5.1.1" targetptr="WBDOD10659"> <ttl>Case Study</ttl> <xreftext>“Case Study”</xreftext> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90743"> <ttl>Step 1: Install ODBC Driver for Excel</ttl> <xreftext>“Step 1: Install ODBC Driver for Excel”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90744"> <ttl>Step 2: Delimit the Data in the Excel File (Optional)</ttl> <xreftext>“Step 2: Delimit the Data in the Excel File (Optional)”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90745"> <ttl>Step 3: Create a System DSN</ttl> <xreftext>“Step 3: Create a System DSN”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90747"> <ttl>Step 4: Create the Heterogeneous Services Initialization File</ttl> <xreftext>“Step 4: Create the Heterogeneous Services Initialization File”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90748"> <ttl>Step 5: Modify the listener.ora file</ttl> <xreftext>“Step 5: Modify the listener.ora file”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90749"> <ttl>Step 6: Create an ODBC Source Module</ttl> <xreftext>“Step 6: Create an ODBC Source Module”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90750"> <ttl>Step 7: Import Metadata from Excel Using the Metadata Import Wizard</ttl> <xreftext>“Step 7: Import Metadata from Excel Using the Metadata Import Wizard”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90751"> <ttl>Step 8: Create a Mapping to Load Data Into the Target Table</ttl> <xreftext>“Step 8: Create a Mapping to Load Data Into the Target Table”</xreftext> </obj> <obj element="bridgehead" href="wbdod10659.htm" number="" targetptr="WBDOD90753"> <ttl>Step 9: Deploy the Mapping</ttl> <xreftext>“Step 9: Deploy the Mapping”</xreftext> </obj> </div> <div element="sect2" href="wbdod10660.htm" number="5.1.2" targetptr="WBDOD10660"> <ttl>Troubleshooting</ttl> <xreftext>“Troubleshooting”</xreftext> <obj element="bridgehead" href="wbdod10660.htm" number="" targetptr="WBDOD90754"> <ttl>Error</ttl> <xreftext>“Error”</xreftext> </obj> <obj element="bridgehead" href="wbdod10660.htm" number="" targetptr="WBDOD90755"> <ttl>Probable Cause</ttl> <xreftext>“Probable Cause”</xreftext> </obj> <obj element="bridgehead" href="wbdod10660.htm" number="" targetptr="WBDOD90756"> <ttl>Action</ttl> <xreftext>“Action”</xreftext> </obj> <obj element="bridgehead" href="wbdod10660.htm" number="" targetptr="WBDOD90757"> <ttl>Error</ttl> <xreftext>“Error”</xreftext> </obj> <obj element="bridgehead" href="wbdod10660.htm" number="" targetptr="WBDOD90758"> <ttl>Probable Cause</ttl> <xreftext>“Probable Cause”</xreftext> </obj> <obj element="bridgehead" href="wbdod10660.htm" number="" targetptr="WBDOD90759"> <ttl>Action</ttl> <xreftext>“Action”</xreftext> </obj> </div> </div> <div element="sect1" href="wbdod10661.htm" number="5.2" targetptr="WBDOD10661"> <ttl>Connecting to SQL Server Through ODBC</ttl> <xreftext>“Connecting to SQL Server Through ODBC”</xreftext> <obj element="bridgehead" href="wbdod10661.htm" number="" targetptr="WBDOD90760"> <ttl>Scenario</ttl> <xreftext>“Scenario”</xreftext> </obj> <obj element="bridgehead" href="wbdod10661.htm" number="" targetptr="WBDOD90761"> <ttl>Solution</ttl> <xreftext>“Solution”</xreftext> </obj> <obj element="bridgehead" href="wbdod10661.htm" number="" targetptr="WBDOD90762"> <ttl>Case Study</ttl> <xreftext>“Case Study”</xreftext> </obj> <div element="sect2" href="wbdod10662.htm" number="5.2.1" targetptr="WBDOD10662"> <ttl>Creating an ODBC Data Source</ttl> <xreftext>“Creating an ODBC Data Source”</xreftext> </div> <div element="sect2" href="wbdod10663.htm" number="5.2.2" targetptr="WBDOD10663"> <ttl>Configuring the Oracle Database Server</ttl> <xreftext>“Configuring the Oracle Database Server”</xreftext> <div element="sect3" href="wbdod10664.htm" number="5.2.2.1" targetptr="WBDOD10664"> <ttl>Creating a Heterogeneous Service Configuration File</ttl> <xreftext>“Creating a Heterogeneous Service Configuration File”</xreftext> </div> <div element="sect3" href="wbdod10665.htm" number="5.2.2.2" targetptr="WBDOD10665"> <ttl>Editing the listener.ora file</ttl> <xreftext>“Editing the listener.ora file”</xreftext> </div> </div> <div element="sect2" href="wbdod10666.htm" number="5.2.3" targetptr="WBDOD10666"> <ttl>Adding the SQL Server as a Source in Warehouse Builder</ttl> <xreftext>“Adding the SQL Server as a Source in Warehouse Builder”</xreftext> </div> <div element="sect2" href="wbdod10668.htm" number="5.2.4" targetptr="WBDOD10668"> <ttl>Troubleshooting</ttl> <xreftext>“Troubleshooting”</xreftext> <obj element="bridgehead" href="wbdod10668.htm" number="" targetptr="WBDOD90763"> <ttl>Error</ttl> <xreftext>“Error”</xreftext> </obj> <obj element="bridgehead" href="wbdod10668.htm" number="" targetptr="WBDOD90764"> <ttl>Probable Cause</ttl> <xreftext>“Probable Cause”</xreftext> </obj> <obj element="bridgehead" href="wbdod10668.htm" number="" targetptr="WBDOD90765"> <ttl>Action</ttl> <xreftext>“Action”</xreftext> </obj> <obj element="bridgehead" href="wbdod10668.htm" number="" targetptr="WBDOD90766"> <ttl>Error</ttl> <xreftext>“Error”</xreftext> </obj> <obj element="bridgehead" href="wbdod10668.htm" number="" targetptr="WBDOD90767"> <ttl>Probable Cause</ttl> <xreftext>“Probable Cause”</xreftext> </obj> <obj element="bridgehead" href="wbdod10668.htm" number="" targetptr="WBDOD90768"> <ttl>Action</ttl> <xreftext>“Action”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="jdbc_connection.htm" number="6" targetptr="WBDOD10505"> <ttl>Connecting to Data Sources Through JDBC</ttl> <xreftext>“Connecting to Data Sources Through JDBC”</xreftext> <div element="sect1" href="jdbc_connection001.htm" number="6.1" targetptr=""> <ttl>Generic Connection Using JDBC</ttl> <xreftext>“Generic Connection Using JDBC”</xreftext> </div> <div element="sect1" href="wbdod90612.htm" number="6.2" targetptr="WBDOD90612"> <ttl>Connecting to DB2 Database</ttl> <xreftext>“Connecting to DB2 Database”</xreftext> <obj element="bridgehead" href="wbdod90612.htm" number="" targetptr="WBDOD90769"> <ttl>JDBC Connection Drivers for DB2</ttl> <xreftext>“JDBC Connection Drivers for DB2”</xreftext> </obj> <obj element="bridgehead" href="wbdod90612.htm" number="" targetptr=""> <ttl>Modifying the ccastart.bat File</ttl> <xreftext>“Modifying the ccastart.bat File”</xreftext> </obj> <div element="sect2" href="wbdod90613.htm" number="6.2.1" targetptr="WBDOD90613"> <ttl>Creating a DB2 Module</ttl> <xreftext>“Creating a DB2 Module”</xreftext> </div> <div element="sect2" href="wbdod90614.htm" number="6.2.2" targetptr="WBDOD90614"> <ttl>Importing Metadata into a DB2 Module</ttl> <xreftext>“Importing Metadata into a DB2 Module”</xreftext> </div> </div> <div element="sect1" href="wbdod90615.htm" number="6.3" targetptr="WBDOD90615"> <ttl>Connecting to SQL Server Database</ttl> <xreftext>“Connecting to SQL Server Database”</xreftext> <obj element="bridgehead" href="wbdod90615.htm" number="" targetptr="WBDOD90770"> <ttl>JDBC Connection Driver for SQL Server</ttl> <xreftext>“JDBC Connection Driver for SQL Server”</xreftext> </obj> <div element="sect2" href="wbdod90616.htm" number="6.3.1" targetptr="WBDOD90616"> <ttl>Creating a SQL Server Module</ttl> <xreftext>“Creating a SQL Server Module”</xreftext> </div> <div element="sect2" href="wbdod90617.htm" number="6.3.2" targetptr="WBDOD90617"> <ttl>Importing Metadata into a SQL Server Module</ttl> <xreftext>“Importing Metadata into a SQL Server Module”</xreftext> </div> </div> <div element="sect1" href="jdbc_connection002.htm" number="6.4" targetptr=""> <ttl>Importing Data from Other Databases Using JDBC</ttl> <xreftext>“Importing Data from Other Databases Using JDBC”</xreftext> </div> </div> <div element="chapter" href="integrating_apps.htm" number="7" targetptr="WBDOD10506"> <ttl>Integrating with Applications</ttl> <xreftext>“Integrating with Applications”</xreftext> <div element="sect1" href="wbdod10617.htm" number="7.1" targetptr="WBDOD10617"> <ttl>Integrating with E-Business Suite</ttl> <xreftext>“Integrating with E-Business Suite”</xreftext> <obj element="bridgehead" href="wbdod10617.htm" number="" targetptr="WBDOD90774"> <ttl>Before You Begin</ttl> <xreftext>“Before You Begin”</xreftext> </obj> <div element="sect2" href="wbdod10618.htm" number="7.1.1" targetptr="WBDOD10618"> <ttl>Importing E-Business Suite Metadata Definitions</ttl> <xreftext>“Importing E-Business Suite Metadata Definitions”</xreftext> <div element="sect3" href="wbdod10619.htm" number="7.1.1.1" targetptr="WBDOD10619"> <ttl>Filtering E-Business Suite Metadata</ttl> <xreftext>“Filtering E-Business Suite Metadata”</xreftext> <div element="sect4" href="wbdod10620.htm" number="7.1.1.1.1" targetptr="WBDOD10620"> <ttl>Filtering E-Business Suite Metadata by Business Domain</ttl> <xreftext>“Filtering E-Business Suite Metadata by Business Domain”</xreftext> </div> <div element="sect4" href="wbdod10621.htm" number="7.1.1.1.2" targetptr="WBDOD10621"> <ttl>Filtering E-Business Suite Metadata by Text String</ttl> <xreftext>“Filtering E-Business Suite Metadata by Text String”</xreftext> </div> </div> <div element="sect3" href="wbdod10622.htm" number="7.1.1.2" targetptr="WBDOD10622"> <ttl>Selecting the Objects</ttl> <xreftext>“Selecting the Objects”</xreftext> </div> <div element="sect3" href="wbdod10623.htm" number="7.1.1.3" targetptr="WBDOD10623"> <ttl>Reviewing Import Summary</ttl> <xreftext>“Reviewing Import Summary”</xreftext> </div> </div> </div> <div element="sect1" href="wbdod10624.htm" number="7.2" targetptr="WBDOD10624"> <ttl>Integrating with PeopleSoft</ttl> <xreftext>“Integrating with PeopleSoft”</xreftext> <div element="sect2" href="wbdod10625.htm" number="7.2.1" targetptr="WBDOD10625"> <ttl>Importing PeopleSoft Metadata Definitions</ttl> <xreftext>“Importing PeopleSoft Metadata Definitions”</xreftext> <div element="sect3" href="wbdod10626.htm" number="7.2.1.1" targetptr="WBDOD10626"> <ttl>Filtering PeopleSoft Metadata</ttl> <xreftext>“Filtering PeopleSoft Metadata”</xreftext> <div element="sect4" href="wbdod10627.htm" number="7.2.1.1.1" targetptr="WBDOD10627"> <ttl>Filtering PeopleSoft Metadata by Business Domain</ttl> <xreftext>“Filtering PeopleSoft Metadata by Business Domain”</xreftext> </div> <div element="sect4" href="wbdod10628.htm" number="7.2.1.1.2" targetptr="WBDOD10628"> <ttl>Filtering PeopleSoft Metadata by Text String</ttl> <xreftext>“Filtering PeopleSoft Metadata by Text String”</xreftext> </div> </div> <div element="sect3" href="wbdod10629.htm" number="7.2.1.2" targetptr="WBDOD10629"> <ttl>Selecting the Objects</ttl> <xreftext>“Selecting the Objects”</xreftext> </div> <div element="sect3" href="wbdod10630.htm" number="7.2.1.3" targetptr="WBDOD10630"> <ttl>Reviewing Import Summary</ttl> <xreftext>“Reviewing Import Summary”</xreftext> </div> </div> </div> <div element="sect1" href="wbdod10631.htm" number="7.3" targetptr="WBDOD10631"> <ttl>Integrating with Siebel</ttl> <xreftext>“Integrating with Siebel”</xreftext> <div element="sect2" href="wbdod10632.htm" number="7.3.1" targetptr="WBDOD10632"> <ttl>Importing Siebel Metadata Definitions</ttl> <xreftext>“Importing Siebel Metadata Definitions”</xreftext> <div element="sect3" href="wbdod10633.htm" number="7.3.1.1" targetptr="WBDOD10633"> <ttl>Creating a Siebel Source Module</ttl> <xreftext>“Creating a Siebel Source Module”</xreftext> </div> <div element="sect3" href="wbdod10634.htm" number="7.3.1.2" targetptr="WBDOD10634"> <ttl>Importing Siebel Metadata</ttl> <xreftext>“Importing Siebel Metadata”</xreftext> <obj element="bridgehead" href="wbdod10634.htm" number="" targetptr="WBDOD90776"> <ttl>Filtering Siebel Metadata by Text String</ttl> <xreftext>“Filtering Siebel Metadata by Text String”</xreftext> </obj> </div> </div> </div> </div> <div element="chapter" href="sap_integrate.htm" number="8" targetptr="WBDOD30500"> <ttl>Extracting Data from SAP Applications</ttl> <xreftext>“Extracting Data from SAP Applications”</xreftext> <div element="sect1" href="wbdod90777.htm" number="8.1" targetptr="WBDOD90777"> <ttl>Why SAP Connector</ttl> <xreftext>“Why SAP Connector”</xreftext> </div> <div element="sect1" href="wbdod90778.htm" number="8.2" targetptr="WBDOD90778"> <ttl>Supported SAP Versions</ttl> <xreftext>“Supported SAP Versions”</xreftext> </div> <div element="sect1" href="wbdod90779.htm" number="8.3" targetptr="WBDOD90779"> <ttl>Overview of SAP Objects</ttl> <xreftext>“Overview of SAP Objects”</xreftext> <div element="sect2" href="wbdod90780.htm" number="8.3.1" targetptr="WBDOD90780"> <ttl>SAP Object Types</ttl> <xreftext>“SAP Object Types”</xreftext> </div> <div element="sect2" href="wbdod90781.htm" number="8.3.2" targetptr="WBDOD90781"> <ttl>SAP Business Domains</ttl> <xreftext>“SAP Business Domains”</xreftext> </div> </div> <div element="sect1" href="wbdod90782.htm" number="8.4" targetptr="WBDOD90782"> <ttl>Overview of the Warehouse Builder-SAP Interaction</ttl> <xreftext>“Overview of the Warehouse Builder-SAP Interaction”</xreftext> <div element="sect2" href="wbdod90783.htm" number="8.4.1" targetptr="WBDOD90783"> <ttl>SAP Function Modules</ttl> <xreftext>“SAP Function Modules”</xreftext> </div> <div element="sect2" href="wbdod90784.htm" number="8.4.2" targetptr="WBDOD90784"> <ttl>Data Rerieval Mechanisms</ttl> <xreftext>“Data Rerieval Mechanisms”</xreftext> <obj element="bridgehead" href="wbdod90784.htm" number="" targetptr="WBDOD90785"> <ttl>Completely Managed By Warehouse Builder</ttl> <xreftext>“Completely Managed By Warehouse Builder”</xreftext> </obj> <obj element="bridgehead" href="wbdod90784.htm" number="" targetptr="WBDOD90786"> <ttl>Managed By Warehouse Builder With SAP Verification</ttl> <xreftext>“Managed By Warehouse Builder With SAP Verification”</xreftext> </obj> <obj element="bridgehead" href="wbdod90784.htm" number="" targetptr="WBDOD90787"> <ttl>Manual</ttl> <xreftext>“Manual”</xreftext> </obj> </div> </div> <div element="sect1" href="wbdod90788.htm" number="8.5" targetptr="WBDOD90788"> <ttl>Implementing an SAP Data Retrieval Mechanism</ttl> <xreftext>“Implementing an SAP Data Retrieval Mechanism”</xreftext> <obj element="bridgehead" href="wbdod90788.htm" number="" targetptr="WBDOD90789"> <ttl>Development Environment</ttl> <xreftext>“Development Environment”</xreftext> </obj> <obj element="bridgehead" href="wbdod90788.htm" number="" targetptr="WBDOD90790"> <ttl>Test and Production Environment</ttl> <xreftext>“Test and Production Environment”</xreftext> </obj> <obj element="bridgehead" href="wbdod90788.htm" number="" targetptr="WBDOD90791"> <ttl>Scenario 1</ttl> <xreftext>“Scenario 1”</xreftext> </obj> <obj element="bridgehead" href="wbdod90788.htm" number="" targetptr="WBDOD90792"> <ttl>Scenario 2</ttl> <xreftext>“Scenario 2”</xreftext> </obj> </div> <div element="sect1" href="wbdod90793.htm" number="8.6" targetptr="WBDOD90793"> <ttl>Connecting to an SAP System</ttl> <xreftext>“Connecting to an SAP System”</xreftext> <div element="sect2" href="wbdod90794.htm" number="8.6.1" targetptr="WBDOD90794"> <ttl>Required Files For SAP Connector</ttl> <xreftext>“Required Files For SAP Connector”</xreftext> <obj element="bridgehead" href="wbdod90794.htm" number="" targetptr="WBDOD90795"> <ttl>Files Required In Windows</ttl> <xreftext>“Files Required In Windows”</xreftext> </obj> <obj element="table" href="wbdod90794.htm" number="8-1" targetptr="WBDOD90796"> <ttl>Required Files for Windows</ttl> <xreftext>“Required Files for Windows”</xreftext> </obj> <obj element="bridgehead" href="wbdod90794.htm" number="" targetptr="WBDOD90797"> <ttl>Files Required In Unix</ttl> <xreftext>“Files Required In Unix”</xreftext> </obj> <obj element="table" href="wbdod90794.htm" number="8-2" targetptr="WBDOD90798"> <ttl>Required Files for Unix</ttl> <xreftext>“Required Files for Unix”</xreftext> </obj> </div> <div element="sect2" href="wbdod90799.htm" number="8.6.2" targetptr="WBDOD90799"> <ttl>Troubleshooting Connection Errors</ttl> <xreftext>“Troubleshooting Connection Errors”</xreftext> <obj element="table" href="wbdod90799.htm" number="8-3" targetptr="WBDOD90800"> <ttl>SAP Connection Errors</ttl> <xreftext>“SAP Connection Errors”</xreftext> </obj> </div> <div element="sect2" href="wbdod90801.htm" number="8.6.3" targetptr="WBDOD90801"> <ttl>Creating SAP Module Definitions</ttl> <xreftext>“Creating SAP Module Definitions”</xreftext> <obj element="bridgehead" href="wbdod90801.htm" number="" targetptr="WBDOD90802"> <ttl>Remote Function Call (RFC)</ttl> <xreftext>“Remote Function Call (RFC)”</xreftext> </obj> <obj element="bridgehead" href="wbdod90801.htm" number="" targetptr="WBDOD90803"> <ttl>SAP Remote Function Call (SAPRFC.INI)</ttl> <xreftext>“SAP Remote Function Call (SAPRFC.INI)”</xreftext> </obj> <div element="sect3" href="new_sap_conn.htm" number="8.6.3.1" targetptr="WBDOD90804"> <ttl>Connecting to an SAP System</ttl> <xreftext>“Connecting to an SAP System”</xreftext> </div> </div> </div> <div element="sect1" href="wbdod90805.htm" number="8.7" targetptr="WBDOD90805"> <ttl>Importing Metadata from SAP Tables</ttl> <xreftext>“Importing Metadata from SAP Tables”</xreftext> <div element="sect2" href="wbdod90806.htm" number="8.7.1" targetptr="WBDOD90806"> <ttl>Importing SAP Metadata Definitions</ttl> <xreftext>“Importing SAP Metadata Definitions”</xreftext> <div element="sect3" href="translate_29.htm" number="8.7.1.1" targetptr="WBDOD90807"> <ttl>Filtering SAP Metadata</ttl> <xreftext>“Filtering SAP Metadata”</xreftext> <div element="sect4" href="wbdod90808.htm" number="8.7.1.1.1" targetptr="WBDOD90808"> <ttl>Filtering SAP Metadata by Business Domain</ttl> <xreftext>“Filtering SAP Metadata by Business Domain”</xreftext> </div> <div element="sect4" href="wbdod90809.htm" number="8.7.1.1.2" targetptr="WBDOD90809"> <ttl>Filtering SAP Metadata by Text String</ttl> <xreftext>“Filtering SAP Metadata by Text String”</xreftext> </div> </div> <div element="sect3" href="wbdod90810.htm" number="8.7.1.2" targetptr="WBDOD90810"> <ttl>Selecting Objects for Metadata Import</ttl> <xreftext>“Selecting Objects for Metadata Import”</xreftext> </div> <div element="sect3" href="translate_31.htm" number="8.7.1.3" targetptr="WBDOD90811"> <ttl>Reviewing Import Summary</ttl> <xreftext>“Reviewing Import Summary”</xreftext> </div> <div element="sect3" href="wbdod90812.htm" number="8.7.1.4" targetptr="WBDOD90812"> <ttl>Reimporting SAP Tables</ttl> <xreftext>“Reimporting SAP Tables”</xreftext> </div> </div> <div element="sect2" href="wbdod90813.htm" number="8.7.2" targetptr="WBDOD90813"> <ttl>Analyzing Metadata Details</ttl> <xreftext>“Analyzing Metadata Details”</xreftext> <obj element="bridgehead" href="wbdod90813.htm" number="" targetptr="WBDOD90814"> <ttl>Column Descriptions</ttl> <xreftext>“Column Descriptions”</xreftext> </obj> <obj element="bridgehead" href="wbdod90813.htm" number="" targetptr="WBDOD90816"> <ttl>Constraints Details</ttl> <xreftext>“Constraints Details”</xreftext> </obj> </div> </div> <div element="sect1" href="wbdod90817.htm" number="8.8" targetptr="WBDOD90817"> <ttl>Creating SAP Extraction Mappings</ttl> <xreftext>“Creating SAP Extraction Mappings”</xreftext> <div element="sect2" href="wbdod90818.htm" number="8.8.1" targetptr="WBDOD90818"> <ttl>Defining an SAP Extraction Mapping</ttl> <xreftext>“Defining an SAP Extraction Mapping”</xreftext> <div element="sect3" href="wbdod90820.htm" number="8.8.1.1" targetptr="WBDOD90820"> <ttl>Adding SAP Tables to the Mapping</ttl> <xreftext>“Adding SAP Tables to the Mapping”</xreftext> </div> <div element="sect3" href="wbdod90821.htm" number="8.8.1.2" targetptr="WBDOD90821"> <ttl>Setting the Loading Type</ttl> <xreftext>“Setting the Loading Type”</xreftext> <obj element="table" href="wbdod90821.htm" number="8-4" targetptr="WBDOD90822"> <ttl>SQL*Loader Code Generated in ABAP</ttl> <xreftext>“SQL*Loader Code Generated in ABAP”</xreftext> </obj> </div> <div element="sect3" href="wbdod90823.htm" number="8.8.1.3" targetptr="WBDOD90823"> <ttl>Setting Configuration Properties for the Mapping</ttl> <xreftext>“Setting Configuration Properties for the Mapping”</xreftext> <obj element="bridgehead" href="wbdod90823.htm" number="" targetptr="WBDOD90824"> <ttl>Setting the Language Parameter</ttl> <xreftext>“Setting the Language Parameter”</xreftext> </obj> <obj element="bridgehead" href="wbdod90823.htm" number="" targetptr="WBDOD90825"> <ttl>Setting the Runtime Parameters</ttl> <xreftext>“Setting the Runtime Parameters”</xreftext> </obj> </div> <div element="sect3" href="wbdod90826.htm" number="8.8.1.4" targetptr="WBDOD90826"> <ttl>Setting the Join Rank</ttl> <xreftext>“Setting the Join Rank”</xreftext> </div> </div> </div> <div element="sect1" href="wbdod90827.htm" number="8.9" targetptr="WBDOD90827"> <ttl>Retrieving Data from the SAP System</ttl> <xreftext>“Retrieving Data from the SAP System”</xreftext> <div element="sect2" href="wbdod90828.htm" number="8.9.1" targetptr="WBDOD90828"> <ttl>Automated System</ttl> <xreftext>“Automated System”</xreftext> <obj element="figure" href="wbdod90828.htm" number="8-1" targetptr="WBDOD90829"> <ttl>Automated Data Retrieval</ttl> <xreftext>“Automated Data Retrieval”</xreftext> </obj> </div> <div element="sect2" href="wbdod90830.htm" number="8.9.2" targetptr="WBDOD90830"> <ttl>Semi Automated System</ttl> <xreftext>“Semi Automated System”</xreftext> </div> <div element="sect2" href="wbdod90832.htm" number="8.9.3" targetptr="WBDOD90832"> <ttl>Manual System</ttl> <xreftext>“Manual System”</xreftext> <obj element="bridgehead" href="wbdod90832.htm" number="" targetptr=""> <ttl>Using SQL*Loader in the Process Flow</ttl> <xreftext>“Using SQL*Loader in the Process Flow”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="business_intelligence.htm" number="9" targetptr="WBDOD10510"> <ttl>Importing Warehouse Builder Data into Business Intelligence Applications</ttl> <xreftext>“Importing Warehouse Builder Data into Business Intelligence Applications”</xreftext> <div element="sect1" href="wbdod10003.htm" number="9.1" targetptr="WBDOD10003"> <ttl>Creating Business Definitions for Oracle BI Discoverer</ttl> <xreftext>“Creating Business Definitions for Oracle BI Discoverer”</xreftext> <div element="sect2" href="f1_iob_eul_module_wiz_welcome.htm" number="9.1.1" targetptr="WBDOD10677"> <ttl>Creating Oracle Discoverer Module</ttl> <xreftext>“Creating Oracle Discoverer Module”</xreftext> <div element="sect3" href="f1_iob_eul_module_wiz_name.htm" number="9.1.1.1" targetptr="WBDOD10678"> <ttl>Naming the Oracle Discoverer Module</ttl> <xreftext>“Naming the Oracle Discoverer Module”</xreftext> </div> <div element="sect3" href="f1_iob_obise_module_wiz_loc_create.htm" number="9.1.1.2" targetptr="WBDOD10679"> <ttl>Setting the Connection Information</ttl> <xreftext>“Setting the Connection Information”</xreftext> <div element="sect4" href="wbdod10680.htm" number="9.1.1.2.1" targetptr="WBDOD10680"> <ttl>Defining Discoverer Locations</ttl> <xreftext>“Defining Discoverer Locations”</xreftext> </div> </div> <div element="sect3" href="wbdod10681.htm" number="9.1.1.3" targetptr="WBDOD10681"> <ttl>Reviewing the Summary Information</ttl> <xreftext>“Reviewing the Summary Information”</xreftext> </div> </div> <div element="sect2" href="wbdod10682.htm" number="9.1.2" targetptr="WBDOD10682"> <ttl>About Item Folders</ttl> <xreftext>“About Item Folders”</xreftext> </div> <div element="sect2" href="wbdod10683.htm" number="9.1.3" targetptr="WBDOD10683"> <ttl>Editing an Item Folder</ttl> <xreftext>“Editing an Item Folder”</xreftext> <div element="sect3" href="wbdod10684.htm" number="9.1.3.1" targetptr="WBDOD10684"> <ttl>Name Editor</ttl> <xreftext>“Name Editor”</xreftext> </div> <div element="sect3" href="f1_iob_folder_wiz_folder_items.htm" number="9.1.3.2" targetptr="WBDOD10685"> <ttl>Source Items Editor</ttl> <xreftext>“Source Items Editor”</xreftext> <obj element="bridgehead" href="f1_iob_folder_wiz_folder_items.htm" number="" targetptr="WBDOD90835"> <ttl>Deleting Items</ttl> <xreftext>“Deleting Items”</xreftext> </obj> </div> <div element="sect3" href="f1_item_fldr_items.htm" number="9.1.3.3" targetptr="WBDOD10686"> <ttl>Items Editor</ttl> <xreftext>“Items Editor”</xreftext> <obj element="bridgehead" href="f1_item_fldr_items.htm" number="" targetptr="WBDOD90836"> <ttl>Item Details</ttl> <xreftext>“Item Details”</xreftext> </obj> <obj element="bridgehead" href="f1_item_fldr_items.htm" number="" targetptr="WBDOD90837"> <ttl>Adding Items Through the Items Editor</ttl> <xreftext>“Adding Items Through the Items Editor”</xreftext> </obj> </div> <div element="sect3" href="f1_item_fldr_joins.htm" number="9.1.3.4" targetptr="WBDOD10687"> <ttl>Joins Editor</ttl> <xreftext>“Joins Editor”</xreftext> </div> <div element="sect3" href="f1_item_fldr_conditions.htm" number="9.1.3.5" targetptr="WBDOD10688"> <ttl>Conditions Editor</ttl> <xreftext>“Conditions Editor”</xreftext> </div> <div element="sect3" href="wbdod90623.htm" number="9.1.3.6" targetptr="WBDOD90623"> <ttl>Composition Editor</ttl> <xreftext>“Composition Editor”</xreftext> <obj element="bridgehead" href="wbdod90623.htm" number="" targetptr="WBDOD90839"> <ttl>Adding Items Through the Composition Editor</ttl> <xreftext>“Adding Items Through the Composition Editor”</xreftext> </obj> <obj element="bridgehead" href="wbdod90623.htm" number="" targetptr="WBDOD90840"> <ttl>Deleting Items</ttl> <xreftext>“Deleting Items”</xreftext> </obj> </div> <div element="sect3" href="wbdod90624.htm" number="9.1.3.7" targetptr="WBDOD90624"> <ttl>General Properties of an Item Folder</ttl> <xreftext>“General Properties of an Item Folder”</xreftext> </div> </div> <div element="sect2" href="f1_iob_folder_wiz_welcome.htm" number="9.1.4" targetptr="WBDOD10689"> <ttl>Creating an Item Folder</ttl> <xreftext>“Creating an Item Folder”</xreftext> <div element="sect3" href="wbdod90625.htm" number="9.1.4.1" targetptr="WBDOD90625"> <ttl>Using the Create Item Folder Wizard</ttl> <xreftext>“Using the Create Item Folder Wizard”</xreftext> </div> <div element="sect3" href="f1_item_fldr_name.htm" number="9.1.4.2" targetptr="WBDOD10690"> <ttl>Naming and Describing the Item Folder</ttl> <xreftext>“Naming and Describing the Item Folder”</xreftext> </div> <div element="sect3" href="f1_item_fldr_source.htm" number="9.1.4.3" targetptr="WBDOD10691"> <ttl>Selecting Source Items</ttl> <xreftext>“Selecting Source Items”</xreftext> </div> <div element="sect3" href="f1_iob_folder_wiz_joins.htm" number="9.1.4.4" targetptr="WBDOD10692"> <ttl>Selecting the Join</ttl> <xreftext>“Selecting the Join”</xreftext> </div> <div element="sect3" href="wbdod10693.htm" number="9.1.4.5" targetptr="WBDOD10693"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> <div element="sect3" href="wbdod90626.htm" number="9.1.4.6" targetptr="WBDOD90626"> <ttl>Using the Graphical Navigator to Create Item Folders</ttl> <xreftext>“Using the Graphical Navigator to Create Item Folders”</xreftext> <obj element="bridgehead" href="wbdod90626.htm" number="" targetptr="WBDOD90841"> <ttl>Using the Menu</ttl> <xreftext>“Using the Menu”</xreftext> </obj> <obj element="bridgehead" href="wbdod90626.htm" number="" targetptr="WBDOD90842"> <ttl>Using the Canvas</ttl> <xreftext>“Using the Canvas”</xreftext> </obj> <obj element="bridgehead" href="wbdod90626.htm" number="" targetptr="WBDOD90843"> <ttl>Steps to Create an Item Folder</ttl> <xreftext>“Steps to Create an Item Folder”</xreftext> </obj> <obj element="bridgehead" href="wbdod90626.htm" number="" targetptr="WBDOD90844"> <ttl>Adding Items to an Item Folder</ttl> <xreftext>“Adding Items to an Item Folder”</xreftext> </obj> </div> <div element="sect3" href="wbdod90628.htm" number="9.1.4.7" targetptr="WBDOD90628"> <ttl>Adding Joins Using the Graphical Navigator</ttl> <xreftext>“Adding Joins Using the Graphical Navigator”</xreftext> </div> <div element="sect3" href="wbdod10754.htm" number="9.1.4.8" targetptr="WBDOD10754"> <ttl>Synchronizing Item Folders</ttl> <xreftext>“Synchronizing Item Folders”</xreftext> </div> <div element="sect3" href="f1_iob_reconcile_dlg.htm" number="9.1.4.9" targetptr="WBDOD10755"> <ttl>Synchronize Item Folder Dialog Box</ttl> <xreftext>“Synchronize Item Folder Dialog Box”</xreftext> </div> </div> <div element="sect2" href="f1_iob_business_area_wiz_welcome.htm" number="9.1.5" targetptr="WBDOD10694"> <ttl>Creating a Business Area</ttl> <xreftext>“Creating a Business Area”</xreftext> <div element="sect3" href="wbdod90629.htm" number="9.1.5.1" targetptr="WBDOD90629"> <ttl>Using the Create Business Area Wizard</ttl> <xreftext>“Using the Create Business Area Wizard”</xreftext> </div> <div element="sect3" href="f1_bus_area_name.htm" number="9.1.5.2" targetptr="WBDOD10695"> <ttl>Naming the Business Area</ttl> <xreftext>“Naming the Business Area”</xreftext> </div> <div element="sect3" href="f1_bus_area_source.htm" number="9.1.5.3" targetptr="WBDOD10696"> <ttl>Selecting the Item Folders</ttl> <xreftext>“Selecting the Item Folders”</xreftext> </div> <div element="sect3" href="wbdod10697.htm" number="9.1.5.4" targetptr="WBDOD10697"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> <div element="sect3" href="wbdod90630.htm" number="9.1.5.5" targetptr="WBDOD90630"> <ttl>Using the Graphical Navigator</ttl> <xreftext>“Using the Graphical Navigator”</xreftext> <obj element="bridgehead" href="wbdod90630.htm" number="" targetptr="WBDOD90845"> <ttl>Using the Menu</ttl> <xreftext>“Using the Menu”</xreftext> </obj> <obj element="bridgehead" href="wbdod90630.htm" number="" targetptr="WBDOD90846"> <ttl>Using the Canvas</ttl> <xreftext>“Using the Canvas”</xreftext> </obj> </div> </div> <div element="sect2" href="wbdod10698.htm" number="9.1.6" targetptr="WBDOD10698"> <ttl>Editing a Business Area</ttl> <xreftext>“Editing a Business Area”</xreftext> <div element="sect3" href="wbdod10699.htm" number="9.1.6.1" targetptr="WBDOD10699"> <ttl>Name Editor</ttl> <xreftext>“Name Editor”</xreftext> </div> <div element="sect3" href="wbdod90631.htm" number="9.1.6.2" targetptr="WBDOD90631"> <ttl>Source Editor</ttl> <xreftext>“Source Editor”</xreftext> </div> <div element="sect3" href="f1_bus_area_contents.htm" number="9.1.6.3" targetptr="WBDOD90632"> <ttl>Contents Editor</ttl> <xreftext>“Contents Editor”</xreftext> </div> </div> <div element="sect2" href="f1_iob_drill_path_wiz_welcome.htm" number="9.1.7" targetptr="WBDOD10701"> <ttl>Creating a Drill Path</ttl> <xreftext>“Creating a Drill Path”</xreftext> <div element="sect3" href="f1_drill_path_name.htm" number="9.1.7.1" targetptr="WBDOD10702"> <ttl>Naming the Drill Path</ttl> <xreftext>“Naming the Drill Path”</xreftext> </div> <div element="sect3" href="f1_drill_path_levels.htm" number="9.1.7.2" targetptr="WBDOD10703"> <ttl>Specifying Drill Levels</ttl> <xreftext>“Specifying Drill Levels”</xreftext> </div> <div element="sect3" href="wbdod10704.htm" number="9.1.7.3" targetptr="WBDOD10704"> <ttl>Specifying the Join</ttl> <xreftext>“Specifying the Join”</xreftext> </div> <div element="sect3" href="wbdod10705.htm" number="9.1.7.4" targetptr="WBDOD10705"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> </div> <div element="sect2" href="wbdod10706.htm" number="9.1.8" targetptr="WBDOD10706"> <ttl>Editing a Drill Path</ttl> <xreftext>“Editing a Drill Path”</xreftext> <div element="sect3" href="wbdod10707.htm" number="9.1.8.1" targetptr="WBDOD10707"> <ttl>Editing the Drill Path Name</ttl> <xreftext>“Editing the Drill Path Name”</xreftext> </div> <div element="sect3" href="wbdod10708.htm" number="9.1.8.2" targetptr="WBDOD10708"> <ttl>Reviewing the Drill Levels in the Drill Path</ttl> <xreftext>“Reviewing the Drill Levels in the Drill Path”</xreftext> </div> </div> <div element="sect2" href="f1_iob_list_of_values_wiz_welcome.htm" number="9.1.9" targetptr="WBDOD10709"> <ttl>Creating Lists of Values</ttl> <xreftext>“Creating Lists of Values”</xreftext> <div element="sect3" href="f1_iob_list_of_values_wiz_name.htm" number="9.1.9.1" targetptr="WBDOD10710"> <ttl>Naming the List of Values</ttl> <xreftext>“Naming the List of Values”</xreftext> </div> <div element="sect3" href="f1_iob_list_of_values_wiz_defining_items.htm" number="9.1.9.2" targetptr="WBDOD10711"> <ttl>Defining Items in a List of Values</ttl> <xreftext>“Defining Items in a List of Values”</xreftext> </div> <div element="sect3" href="f1_iob_list_of_values_wiz_referencing_items.htm" number="9.1.9.3" targetptr="WBDOD10712"> <ttl>Referencing Items in a List of Values</ttl> <xreftext>“Referencing Items in a List of Values”</xreftext> </div> <div element="sect3" href="wbdod10713.htm" number="9.1.9.4" targetptr="WBDOD10713"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> </div> <div element="sect2" href="wbdod10714.htm" number="9.1.10" targetptr="WBDOD10714"> <ttl>Editing Lists of Values</ttl> <xreftext>“Editing Lists of Values”</xreftext> <div element="sect3" href="wbdod10715.htm" number="9.1.10.1" targetptr="WBDOD10715"> <ttl>Editing the Name</ttl> <xreftext>“Editing the Name”</xreftext> </div> <div element="sect3" href="wbdod10716.htm" number="9.1.10.2" targetptr="WBDOD10716"> <ttl>Editing the Defining Items</ttl> <xreftext>“Editing the Defining Items”</xreftext> </div> <div element="sect3" href="wbdod10717.htm" number="9.1.10.3" targetptr="WBDOD10717"> <ttl>Editing the Referencing Items</ttl> <xreftext>“Editing the Referencing Items”</xreftext> </div> <div element="sect3" href="f1_iob_list_of_values_wiz_options.htm" number="9.1.10.4" targetptr="WBDOD10718"> <ttl>Editing the Options</ttl> <xreftext>“Editing the Options”</xreftext> </div> </div> <div element="sect2" href="f1_iob_alternative_sort_wiz_welcome.htm" number="9.1.11" targetptr="WBDOD10719"> <ttl>Creating Alternative Sort Orders</ttl> <xreftext>“Creating Alternative Sort Orders”</xreftext> <div element="sect3" href="f1_iob_alternative_sort_wiz_name.htm" number="9.1.11.1" targetptr="WBDOD10720"> <ttl>Naming the Alternative Sort Order</ttl> <xreftext>“Naming the Alternative Sort Order”</xreftext> </div> <div element="sect3" href="f1_iob_alternative_sort_wiz_defining_item.htm" number="9.1.11.2" targetptr="WBDOD10721"> <ttl>Defining Item for the Alternative Sort Order</ttl> <xreftext>“Defining Item for the Alternative Sort Order”</xreftext> </div> <div element="sect3" href="f1_iob_alternative_sort_wiz_defining_order_item.htm" number="9.1.11.3" targetptr="WBDOD10722"> <ttl>Defining Order Item for the Alternative Sort Order</ttl> <xreftext>“Defining Order Item for the Alternative Sort Order”</xreftext> </div> <div element="sect3" href="f1_iob_alternative_sort_wiz_referencing_items.htm" number="9.1.11.4" targetptr="WBDOD10723"> <ttl>Referencing Items for the Alternative Sort Order</ttl> <xreftext>“Referencing Items for the Alternative Sort Order”</xreftext> </div> <div element="sect3" href="f1_iob_item_class_referencing_selection.htm" number="9.1.11.5" targetptr="WBDOD10724"> <ttl>Referencing Selection Panel for the Alternative Sort Order</ttl> <xreftext>“Referencing Selection Panel for the Alternative Sort Order”</xreftext> </div> <div element="sect3" href="wbdod10725.htm" number="9.1.11.6" targetptr="WBDOD10725"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> </div> <div element="sect2" href="wbdod10726.htm" number="9.1.12" targetptr="WBDOD10726"> <ttl>Editing Alternative Sort Orders</ttl> <xreftext>“Editing Alternative Sort Orders”</xreftext> <div element="sect3" href="wbdod10727.htm" number="9.1.12.1" targetptr="WBDOD10727"> <ttl>Editing the Alternative Sort Order Name</ttl> <xreftext>“Editing the Alternative Sort Order Name”</xreftext> </div> <div element="sect3" href="wbdod10728.htm" number="9.1.12.2" targetptr="WBDOD10728"> <ttl>Editing the Defining Item</ttl> <xreftext>“Editing the Defining Item”</xreftext> </div> <div element="sect3" href="wbdod10729.htm" number="9.1.12.3" targetptr="WBDOD10729"> <ttl>Editing the Defining Order Item</ttl> <xreftext>“Editing the Defining Order Item”</xreftext> </div> <div element="sect3" href="wbdod10730.htm" number="9.1.12.4" targetptr="WBDOD10730"> <ttl>Editing the Referencing Items</ttl> <xreftext>“Editing the Referencing Items”</xreftext> </div> <div element="sect3" href="f1_iob_alternative_sort_wiz_options.htm" number="9.1.12.5" targetptr="WBDOD10731"> <ttl>Editing the Options</ttl> <xreftext>“Editing the Options”</xreftext> </div> </div> <div element="sect2" href="f1_iob_drill_to_detail_wiz_welcome.htm" number="9.1.13" targetptr="WBDOD10732"> <ttl>Creating Drills to Detail</ttl> <xreftext>“Creating Drills to Detail”</xreftext> <div element="sect3" href="f1_iob_drill_to_det_wiz_nam.htm" number="9.1.13.1" targetptr="WBDOD10733"> <ttl>Create Drill to Detail</ttl> <xreftext>“Create Drill to Detail”</xreftext> </div> </div> <div element="sect2" href="wbdod10734.htm" number="9.1.14" targetptr="WBDOD10734"> <ttl>Editing Drills to Detail</ttl> <xreftext>“Editing Drills to Detail”</xreftext> </div> <div element="sect2" href="f1_iob_function_wiz_welcome.htm" number="9.1.15" targetptr="WBDOD10735"> <ttl>Creating Registered Functions</ttl> <xreftext>“Creating Registered Functions”</xreftext> <div element="sect3" href="f1_iob_function_wiz_name.htm" number="9.1.15.1" targetptr="WBDOD10736"> <ttl>Naming the Registered Function</ttl> <xreftext>“Naming the Registered Function”</xreftext> </div> <div element="sect3" href="f1_iob_function_wiz_parameters.htm" number="9.1.15.2" targetptr="WBDOD10737"> <ttl>Specifying the Function Parameters</ttl> <xreftext>“Specifying the Function Parameters”</xreftext> </div> <div element="sect3" href="wbdod10738.htm" number="9.1.15.3" targetptr="WBDOD10738"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> </div> <div element="sect2" href="wbdod10739.htm" number="9.1.16" targetptr="WBDOD10739"> <ttl>Editing Registered Functions</ttl> <xreftext>“Editing Registered Functions”</xreftext> <div element="sect3" href="wbdod10740.htm" number="9.1.16.1" targetptr="WBDOD10740"> <ttl>Renaming a Registered Function</ttl> <xreftext>“Renaming a Registered Function”</xreftext> </div> <div element="sect3" href="wbdod10741.htm" number="9.1.16.2" targetptr="WBDOD10741"> <ttl>Modifying the Parameters of a Registered Function</ttl> <xreftext>“Modifying the Parameters of a Registered Function”</xreftext> </div> </div> </div> <div element="sect1" href="wbdod10001.htm" number="9.2" targetptr="WBDOD10001"> <ttl>Configuring Discoverer Objects</ttl> <xreftext>“Configuring Discoverer Objects”</xreftext> <div element="sect2" href="wbdod10758.htm" number="9.2.1" targetptr="WBDOD10758"> <ttl>Configuration Parameters for Oracle Discoverer modules</ttl> <xreftext>“Configuration Parameters for Oracle Discoverer modules”</xreftext> </div> <div element="sect2" href="wbdod10759.htm" number="9.2.2" targetptr="WBDOD10759"> <ttl>Configuration Parameters for Item Folders</ttl> <xreftext>“Configuration Parameters for Item Folders”</xreftext> </div> <div element="sect2" href="wbdod10760.htm" number="9.2.3" targetptr="WBDOD10760"> <ttl>Configuration Parameters for Registered Functions</ttl> <xreftext>“Configuration Parameters for Registered Functions”</xreftext> </div> </div> <div element="sect1" href="wbdod90633.htm" number="9.3" targetptr="WBDOD90633"> <ttl>Deploying Business Definitions to Oracle BI Discoverer</ttl> <xreftext>“Deploying Business Definitions to Oracle BI Discoverer”</xreftext> <obj element="table" href="wbdod90633.htm" number="9-1" targetptr="WBDOD90848"> <ttl>Different Methods of Deploying Business Definitions</ttl> <xreftext>“Different Methods of Deploying Business Definitions”</xreftext> </obj> <div element="sect2" href="wbdod90634.htm" number="9.3.1" targetptr="WBDOD90634"> <ttl>Directly Deploying Business Definitions to Oracle BI Discoverer</ttl> <xreftext>“Directly Deploying Business Definitions to Oracle BI Discoverer”</xreftext> </div> <div element="sect2" href="wbdod90635.htm" number="9.3.2" targetptr="WBDOD90635"> <ttl>Deploying Business Definitions to Earlier Versions of Oracle BI Discoverer</ttl> <xreftext>“Deploying Business Definitions to Earlier Versions of Oracle BI Discoverer”</xreftext> </div> <div element="sect2" href="wbdod90636.htm" number="9.3.3" targetptr="WBDOD90636"> <ttl>Indirectly Deploying Business Definitions to Oracle BI Discoverer</ttl> <xreftext>“Indirectly Deploying Business Definitions to Oracle BI Discoverer”</xreftext> </div> </div> <div element="sect1" href="wbdod10761.htm" number="9.4" targetptr="WBDOD10761"> <ttl>Accessing BI Objects Using Oracle BI Discoverer</ttl> <xreftext>“Accessing BI Objects Using Oracle BI Discoverer”</xreftext> <div element="sect2" href="wbdod10762.htm" number="9.4.1" targetptr="WBDOD10762"> <ttl>Using Business Definitions in Oracle BI Discoverer</ttl> <xreftext>“Using Business Definitions in Oracle BI Discoverer”</xreftext> </div> </div> <div element="sect1" href="wbdod10004.htm" number="9.5" targetptr="WBDOD10004"> <ttl>Creating Business Definitions for OBIEE</ttl> <xreftext>“Creating Business Definitions for OBIEE”</xreftext> <div element="sect2" href="wbdod90637.htm" number="9.5.1" targetptr="WBDOD90637"> <ttl>Creating an Oracle Business Intelligence Module</ttl> <xreftext>“Creating an Oracle Business Intelligence Module”</xreftext> <div element="sect3" href="wbdod90850.htm" number="9.5.1.1" targetptr="WBDOD90850"> <ttl>Defining Oracle Business Intelligence Location</ttl> <xreftext>“Defining Oracle Business Intelligence Location”</xreftext> </div> </div> <div element="sect2" href="wbdod90638.htm" number="9.5.2" targetptr="WBDOD90638"> <ttl>About Logical Tables</ttl> <xreftext>“About Logical Tables”</xreftext> </div> <div element="sect2" href="wbdod90639.htm" number="9.5.3" targetptr="WBDOD90639"> <ttl>Editing a Logical Table</ttl> <xreftext>“Editing a Logical Table”</xreftext> <div element="sect3" href="wbdod90640.htm" number="9.5.3.1" targetptr="WBDOD90640"> <ttl>Name Editor</ttl> <xreftext>“Name Editor”</xreftext> </div> <div element="sect3" href="f1_iob_folder_wiz_folder_items001.htm" number="9.5.3.2" targetptr="WBDOD90641"> <ttl>Source Items Editor</ttl> <xreftext>“Source Items Editor”</xreftext> <obj element="bridgehead" href="f1_iob_folder_wiz_folder_items001.htm" number="" targetptr="WBDOD90851"> <ttl>Adding Items Through the Source Items Editor</ttl> <xreftext>“Adding Items Through the Source Items Editor”</xreftext> </obj> <obj element="bridgehead" href="f1_iob_folder_wiz_folder_items001.htm" number="" targetptr="WBDOD90852"> <ttl>Deleting Items</ttl> <xreftext>“Deleting Items”</xreftext> </obj> </div> <div element="sect3" href="f1_log_tab_items.htm" number="9.5.3.3" targetptr="WBDOD90642"> <ttl>Items Editor</ttl> <xreftext>“Items Editor”</xreftext> <obj element="bridgehead" href="f1_log_tab_items.htm" number="" targetptr="WBDOD90853"> <ttl>Item Details</ttl> <xreftext>“Item Details”</xreftext> </obj> <obj element="bridgehead" href="f1_log_tab_items.htm" number="" targetptr="WBDOD90854"> <ttl>Adding Items Through Items Editor</ttl> <xreftext>“Adding Items Through Items Editor”</xreftext> </obj> </div> <div element="sect3" href="f1_log_tab_joins.htm" number="9.5.3.4" targetptr="WBDOD90643"> <ttl>Joins Editor</ttl> <xreftext>“Joins Editor”</xreftext> <obj element="bridgehead" href="f1_log_tab_joins.htm" number="" targetptr="WBDOD90856"> <ttl>Properties of a Join</ttl> <xreftext>“Properties of a Join”</xreftext> </obj> </div> <div element="sect3" href="wbdod90644.htm" number="9.5.3.5" targetptr="WBDOD90644"> <ttl>Composition Editor</ttl> <xreftext>“Composition Editor”</xreftext> <obj element="bridgehead" href="wbdod90644.htm" number="" targetptr="WBDOD90857"> <ttl>Adding Items Through the Composition Editor</ttl> <xreftext>“Adding Items Through the Composition Editor”</xreftext> </obj> <obj element="bridgehead" href="wbdod90644.htm" number="" targetptr="WBDOD90858"> <ttl>Deleting Items</ttl> <xreftext>“Deleting Items”</xreftext> </obj> </div> </div> <div element="sect2" href="f1_iob_folder_wiz_welcome001.htm" number="9.5.4" targetptr="WBDOD90646"> <ttl>Creating a Logical Table</ttl> <xreftext>“Creating a Logical Table”</xreftext> <div element="sect3" href="wbdod90647.htm" number="9.5.4.1" targetptr="WBDOD90647"> <ttl>Using the Create Logical Table Wizard</ttl> <xreftext>“Using the Create Logical Table Wizard”</xreftext> </div> <div element="sect3" href="f1_log_tab_name.htm" number="9.5.4.2" targetptr="WBDOD90648"> <ttl>Naming and Describing the Logical Table</ttl> <xreftext>“Naming and Describing the Logical Table”</xreftext> </div> <div element="sect3" href="f1_log_tab_source.htm" number="9.5.4.3" targetptr="WBDOD90649"> <ttl>Selecting Source Items</ttl> <xreftext>“Selecting Source Items”</xreftext> </div> <div element="sect3" href="f1_log_tab_joins001.htm" number="9.5.4.4" targetptr="WBDOD90650"> <ttl>Selecting the Foreign Key</ttl> <xreftext>“Selecting the Foreign Key”</xreftext> </div> <div element="sect3" href="wbdod90651.htm" number="9.5.4.5" targetptr="WBDOD90651"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> <div element="sect3" href="wbdod90652.htm" number="9.5.4.6" targetptr="WBDOD90652"> <ttl>Using the Graphical Navigator to Create Logical Tables</ttl> <xreftext>“Using the Graphical Navigator to Create Logical Tables”</xreftext> <obj element="bridgehead" href="wbdod90652.htm" number="" targetptr="WBDOD90859"> <ttl>Using the Menu</ttl> <xreftext>“Using the Menu”</xreftext> </obj> <obj element="bridgehead" href="wbdod90652.htm" number="" targetptr="WBDOD90860"> <ttl>Using the Canvas</ttl> <xreftext>“Using the Canvas”</xreftext> </obj> <obj element="bridgehead" href="wbdod90652.htm" number="" targetptr="WBDOD90861"> <ttl>Steps to Create a Logical Table</ttl> <xreftext>“Steps to Create a Logical Table”</xreftext> </obj> <obj element="bridgehead" href="wbdod90652.htm" number="" targetptr="WBDOD90862"> <ttl>Adding Items to a Logical Table</ttl> <xreftext>“Adding Items to a Logical Table”</xreftext> </obj> <obj element="bridgehead" href="wbdod90652.htm" number="" targetptr="WBDOD90863"> <ttl>Properties of a Logical Table</ttl> <xreftext>“Properties of a Logical Table”</xreftext> </obj> </div> <div element="sect3" href="wbdod90655.htm" number="9.5.4.7" targetptr="WBDOD90655"> <ttl>Adding Joins Using the Graphical Navigator</ttl> <xreftext>“Adding Joins Using the Graphical Navigator”</xreftext> </div> <div element="sect3" href="wbdod90656.htm" number="9.5.4.8" targetptr="WBDOD90656"> <ttl>Synchronizing Logical Tables</ttl> <xreftext>“Synchronizing Logical Tables”</xreftext> </div> <div element="sect3" href="f1_iob_reconcile_dlg001.htm" number="9.5.4.9" targetptr="WBDOD90657"> <ttl>Synchronize Logical Table Dialog Box</ttl> <xreftext>“Synchronize Logical Table Dialog Box”</xreftext> </div> </div> <div element="sect2" href="f1_iob_drill_path_wiz_welcome001.htm" number="9.5.5" targetptr="WBDOD90669"> <ttl>Creating a Dimension Drill Path</ttl> <xreftext>“Creating a Dimension Drill Path”</xreftext> <div element="sect3" href="f1_dim_drill_path_name.htm" number="9.5.5.1" targetptr="WBDOD90670"> <ttl>Naming the Dimension Drill Path</ttl> <xreftext>“Naming the Dimension Drill Path”</xreftext> </div> <div element="sect3" href="f1_dim_drill_levels.htm" number="9.5.5.2" targetptr="WBDOD90671"> <ttl>Specifying Drill Levels</ttl> <xreftext>“Specifying Drill Levels”</xreftext> </div> <div element="sect3" href="f1_dim_drill_level_keys.htm" number="9.5.5.3" targetptr="WBDOD90865"> <ttl>Specifying the Drill Level Key</ttl> <xreftext>“Specifying the Drill Level Key”</xreftext> </div> <div element="sect3" href="wbdod90673.htm" number="9.5.5.4" targetptr="WBDOD90673"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> <div element="sect3" href="wbdod90866.htm" number="9.5.5.5" targetptr="WBDOD90866"> <ttl>Properties of a Dimensional Drill Path</ttl> <xreftext>“Properties of a Dimensional Drill Path”</xreftext> </div> </div> <div element="sect2" href="wbdod90674.htm" number="9.5.6" targetptr="WBDOD90674"> <ttl>Editing a Dimension Drill Path</ttl> <xreftext>“Editing a Dimension Drill Path”</xreftext> <div element="sect3" href="wbdod90675.htm" number="9.5.6.1" targetptr="WBDOD90675"> <ttl>Editing the Dimension Drill Path Name</ttl> <xreftext>“Editing the Dimension Drill Path Name”</xreftext> </div> <div element="sect3" href="wbdod90676.htm" number="9.5.6.2" targetptr="WBDOD90676"> <ttl>Reviewing the Drill Levels in the Dimension Drill Path</ttl> <xreftext>“Reviewing the Drill Levels in the Dimension Drill Path”</xreftext> </div> </div> <div element="sect2" href="f1_iob_business_area_wiz_welcome001.htm" number="9.5.7" targetptr="WBDOD90658"> <ttl>Creating a Catalog Folder</ttl> <xreftext>“Creating a Catalog Folder”</xreftext> <div element="sect3" href="wbdod90659.htm" number="9.5.7.1" targetptr="WBDOD90659"> <ttl>Using the Create Catalog Folder Wizard</ttl> <xreftext>“Using the Create Catalog Folder Wizard”</xreftext> </div> <div element="sect3" href="f1_cat_fldr_name.htm" number="9.5.7.2" targetptr="WBDOD90660"> <ttl>Naming the Catalog Folder</ttl> <xreftext>“Naming the Catalog Folder”</xreftext> </div> <div element="sect3" href="f1_cat_fldr_source.htm" number="9.5.7.3" targetptr="WBDOD90661"> <ttl>Selecting the Source</ttl> <xreftext>“Selecting the Source”</xreftext> </div> <div element="sect3" href="wbdod90662.htm" number="9.5.7.4" targetptr="WBDOD90662"> <ttl>Reviewing the Summary</ttl> <xreftext>“Reviewing the Summary”</xreftext> </div> <div element="sect3" href="wbdod90663.htm" number="9.5.7.5" targetptr="WBDOD90663"> <ttl>Using the Graphical Navigator</ttl> <xreftext>“Using the Graphical Navigator”</xreftext> <obj element="bridgehead" href="wbdod90663.htm" number="" targetptr="WBDOD90867"> <ttl>Using the Menu</ttl> <xreftext>“Using the Menu”</xreftext> </obj> <obj element="bridgehead" href="wbdod90663.htm" number="" targetptr="WBDOD90868"> <ttl>Using the Canvas</ttl> <xreftext>“Using the Canvas”</xreftext> </obj> </div> </div> <div element="sect2" href="wbdod90664.htm" number="9.5.8" targetptr="WBDOD90664"> <ttl>Editing a Catalog Folder</ttl> <xreftext>“Editing a Catalog Folder”</xreftext> <div element="sect3" href="wbdod90665.htm" number="9.5.8.1" targetptr="WBDOD90665"> <ttl>Name Editor</ttl> <xreftext>“Name Editor”</xreftext> </div> <div element="sect3" href="wbdod90666.htm" number="9.5.8.2" targetptr="WBDOD90666"> <ttl>Source Editor</ttl> <xreftext>“Source Editor”</xreftext> </div> <div element="sect3" href="f1_cat_fldr_contents.htm" number="9.5.8.3" targetptr="WBDOD90667"> <ttl>Contents Editor</ttl> <xreftext>“Contents Editor”</xreftext> </div> </div> </div> <div element="sect1" href="wbdod90869.htm" number="9.6" targetptr="WBDOD90869"> <ttl>Configuring Oracle Business Intelligence Objects</ttl> <xreftext>“Configuring Oracle Business Intelligence Objects”</xreftext> <div element="sect2" href="wbdod90870.htm" number="9.6.1" targetptr="WBDOD90870"> <ttl>Configuration Parameters for Oracle Business Intelligence Modules</ttl> <xreftext>“Configuration Parameters for Oracle Business Intelligence Modules”</xreftext> </div> </div> <div element="sect1" href="wbdod10675.htm" number="9.7" targetptr="WBDOD10675"> <ttl>Accessing BI Objects Using OBIEE</ttl> <xreftext>“Accessing BI Objects Using OBIEE”</xreftext> <div element="sect2" href="wbdod90871.htm" number="9.7.1" targetptr="WBDOD90871"> <ttl>Merging Updated RPD Files</ttl> <xreftext>“Merging Updated RPD Files”</xreftext> <obj element="bridgehead" href="wbdod90871.htm" number="" targetptr="WBDOD90872"> <ttl>Example Scenario</ttl> <xreftext>“Example Scenario”</xreftext> </obj> </div> </div> <div element="sect1" href="f1_iob_derivation_wiz_welcome.htm" number="9.8" targetptr="WBDOD10002"> <ttl>Deriving BI Objects</ttl> <xreftext>“Deriving BI Objects”</xreftext> <div element="sect2" href="f1_iob_derivation_wiz_source_items.htm" number="9.8.1" targetptr="WBDOD10743"> <ttl>Selecting Source Objects</ttl> <xreftext>“Selecting Source Objects”</xreftext> </div> <div element="sect2" href="f1_iob_derivation_wiz_target.htm" number="9.8.2" targetptr="WBDOD10744"> <ttl>Selecting a Target for the Derived Objects</ttl> <xreftext>“Selecting a Target for the Derived Objects”</xreftext> </div> <div element="sect2" href="f1_iob_derivation_wiz_rules.htm" number="9.8.3" targetptr="WBDOD10745"> <ttl>Specifying Derivation Rules</ttl> <xreftext>“Specifying Derivation Rules”</xreftext> <obj element="bridgehead" href="f1_iob_derivation_wiz_rules.htm" number="" targetptr="WBDOD90873"> <ttl>Setting Global Rules</ttl> <xreftext>“Setting Global Rules”</xreftext> </obj> </div> <div element="sect2" href="f1_iob_derivation_wiz_pre_derivation.htm" number="9.8.4" targetptr="WBDOD10746"> <ttl>Reviewing the Pre Derivation Rules</ttl> <xreftext>“Reviewing the Pre Derivation Rules”</xreftext> </div> <div element="sect2" href="f1_iob_derivation_wiz_progress.htm" number="9.8.5" targetptr="WBDOD10747"> <ttl>Reviewing Derivation Progress</ttl> <xreftext>“Reviewing Derivation Progress”</xreftext> </div> <div element="sect2" href="wbdod10748.htm" number="9.8.6" targetptr="WBDOD10748"> <ttl>Finishing the Derivation</ttl> <xreftext>“Finishing the Derivation”</xreftext> </div> </div> </div> <div element="chapter" href="imp_thirdparty_design.htm" number="10" targetptr="WBDOD10504"> <ttl>Importing Design Definitions from Third- Party Design Tools</ttl> <xreftext>“Importing Design Definitions from Third- Party Design Tools”</xreftext> <div element="sect1" href="wbdod10604.htm" number="10.1" targetptr="WBDOD10604"> <ttl>Using Oracle Designer 6i/9i Sources</ttl> <xreftext>“Using Oracle Designer 6<span class="italic">i</span>/9<span class="italic">i</span> Sources”</xreftext> <div element="sect2" href="wbdod10605.htm" number="10.1.1" targetptr="WBDOD10605"> <ttl>Using Designer 6i/9i as a Metadata Source</ttl> <xreftext>“Using Designer 6<span class="italic">i</span>/9<span class="italic">i </span>as<span class="italic"> </span>a Metadata Source”</xreftext> </div> </div> </div> <div element="chapter" href="platform_extensions.htm" number="11" targetptr="CHDHEGEX"> <ttl>Creating New Platforms</ttl> <xreftext>“Creating New Platforms”</xreftext> <div element="sect1" href="platform_extensions001.htm" number="11.1" targetptr="CIHBIHCD"> <ttl>Creating a New Platform</ttl> <xreftext>“Creating a New Platform”</xreftext> </div> <div element="sect1" href="platform_extensions002.htm" number="11.2" targetptr="CIHEBDGB"> <ttl>Defining the Properties of a New Platform</ttl> <xreftext>“Defining the Properties of a New Platform”</xreftext> <obj element="table" href="platform_extensions002.htm" number="11-1" targetptr=""> <ttl>Properties of a Platform</ttl> <xreftext>“Properties of a Platform”</xreftext> </obj> <div element="sect2" href="platform_extensions003.htm" number="11.2.1" targetptr=""> <ttl>Defining the Platform Type</ttl> <xreftext>“Defining the Platform Type”</xreftext> <obj element="table" href="platform_extensions003.htm" number="11-2" targetptr=""> <ttl>Properties of Data Type</ttl> <xreftext>“Properties of Data Type”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions004.htm" number="11.2.2" targetptr=""> <ttl>Defining the Data Type Map</ttl> <xreftext>“Defining the Data Type Map”</xreftext> <obj element="table" href="platform_extensions004.htm" number="11-3" targetptr=""> <ttl>Data Type Mapping Properties</ttl> <xreftext>“Data Type Mapping Properties”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions005.htm" number="11.2.3" targetptr=""> <ttl>Generic Data Types Supported in Warehouse Builder</ttl> <xreftext>“Generic Data Types Supported in Warehouse Builder”</xreftext> <obj element="table" href="platform_extensions005.htm" number="11-4" targetptr=""> <ttl>Generic Data Types</ttl> <xreftext>“Generic Data Types”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions006.htm" number="11.2.4" targetptr=""> <ttl>DB2 Data Types Mapping</ttl> <xreftext>“DB2 Data Types Mapping”</xreftext> <obj element="table" href="platform_extensions006.htm" number="11-5" targetptr=""> <ttl>DB2 Data Types to Generic Data Types</ttl> <xreftext>“DB2 Data Types to Generic Data Types”</xreftext> </obj> <obj element="table" href="platform_extensions006.htm" number="11-6" targetptr=""> <ttl>Generic Data Types to DB2 Data Types</ttl> <xreftext>“Generic Data Types to DB2 Data Types”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions007.htm" number="11.2.5" targetptr=""> <ttl>Informix Data Types Mapping</ttl> <xreftext>“Informix Data Types Mapping”</xreftext> <obj element="table" href="platform_extensions007.htm" number="11-7" targetptr=""> <ttl>Informix Data Types to Generic Data Types</ttl> <xreftext>“Informix Data Types to Generic Data Types”</xreftext> </obj> <obj element="table" href="platform_extensions007.htm" number="11-8" targetptr=""> <ttl>Generic Data Type to Informix Data Type</ttl> <xreftext>“Generic Data Type to Informix Data Type”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions008.htm" number="11.2.6" targetptr=""> <ttl>MS SQL Server Data Types Mapping</ttl> <xreftext>“MS SQL Server Data Types Mapping”</xreftext> <obj element="table" href="platform_extensions008.htm" number="11-9" targetptr=""> <ttl>MS SQL Server Data Types to Generic Data Types</ttl> <xreftext>“MS SQL Server Data Types to Generic Data Types”</xreftext> </obj> <obj element="table" href="platform_extensions008.htm" number="11-10" targetptr=""> <ttl>Generic Data Types to MS SQL Server Data Types</ttl> <xreftext>“Generic Data Types to MS SQL Server Data Types”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions009.htm" number="11.2.7" targetptr=""> <ttl>MySQL Data Types Mapping</ttl> <xreftext>“MySQL Data Types Mapping”</xreftext> <obj element="table" href="platform_extensions009.htm" number="11-11" targetptr=""> <ttl>MySQL Data Types to Generic Data Types</ttl> <xreftext>“MySQL Data Types to Generic Data Types”</xreftext> </obj> <obj element="table" href="platform_extensions009.htm" number="11-12" targetptr=""> <ttl>Generic Data Types to MySQL Data Types</ttl> <xreftext>“Generic Data Types to MySQL Data Types”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions010.htm" number="11.2.8" targetptr=""> <ttl>Teradata Data Type Mapping</ttl> <xreftext>“Teradata Data Type Mapping”</xreftext> <obj element="table" href="platform_extensions010.htm" number="11-13" targetptr=""> <ttl>Teradata Data Types to Generic Data Types</ttl> <xreftext>“Teradata Data Types to Generic Data Types”</xreftext> </obj> <obj element="table" href="platform_extensions010.htm" number="11-14" targetptr=""> <ttl>Generic Data Type to Teradata Data Type</ttl> <xreftext>“Generic Data Type to Teradata Data Type”</xreftext> </obj> </div> <div element="sect2" href="platform_extensions011.htm" number="11.2.9" targetptr=""> <ttl>Creating Modules Based on a Platform</ttl> <xreftext>“Creating Modules Based on a Platform”</xreftext> <obj element="bridgehead" href="platform_extensions011.htm" number="" targetptr="CIHBHCGB"> <ttl>Providing a Name and Access Method</ttl> <xreftext>“Providing a Name and Access Method”</xreftext> </obj> <obj element="bridgehead" href="platform_extensions011.htm" number="" targetptr="CIHIFAAA"> <ttl>Providing Connection Information</ttl> <xreftext>“Providing Connection Information”</xreftext> </obj> </div> </div> <div element="sect1" href="platform_extensions012.htm" number="11.3" targetptr="CIHGHHAB"> <ttl>Creating a Microsoft Excel Platform</ttl> <xreftext>“Creating a Microsoft Excel Platform”</xreftext> <div element="sect2" href="platform_extensions013.htm" number="11.3.1" targetptr=""> <ttl>Importing an Excel Worksheet</ttl> <xreftext>“Importing an Excel Worksheet”</xreftext> </div> </div> <div element="sect1" href="platform_extensions014.htm" number="11.4" targetptr="CIHFBBFG"> <ttl>Using Custom Metadata Import in Platforms</ttl> <xreftext>“Using Custom Metadata Import in Platforms”</xreftext> <div element="sect2" href="platform_extensions015.htm" number="11.4.1" targetptr=""> <ttl>Implementing SQL-Based CMI Import for DB2 UDB</ttl> <xreftext>“Implementing SQL-Based CMI Import for DB2 UDB”</xreftext> <obj element="example" href="platform_extensions015.htm" number="11-1" targetptr="CIHBJFCB"> <ttl>Platform Definition for IBM DB2 UDB</ttl> <xreftext>“Platform Definition for IBM DB2 UDB”</xreftext> </obj> <obj element="example" href="platform_extensions015.htm" number="11-2" targetptr="CIHIJABJ"> <ttl>CMI Definition File</ttl> <xreftext>“CMI Definition File”</xreftext> </obj> </div> </div> <div element="sect1" href="platform_extensions016.htm" number="11.5" targetptr=""> <ttl>Defining Other Platforms</ttl> <xreftext>“Defining Other Platforms”</xreftext> <obj element="table" href="platform_extensions016.htm" number="11-15" targetptr=""> <ttl>JDBC Requirements for Different Platforms</ttl> <xreftext>“JDBC Requirements for Different Platforms”</xreftext> </obj> </div> </div> <div element="chapter" href="knowledge_modules.htm" number="12" targetptr="WBDOD90618"> <ttl>Using Code Templates to Load and Transfer Data</ttl> <xreftext>“Using Code Templates to Load and Transfer Data”</xreftext> <div element="sect1" href="wbdod07001.htm" number="12.1" targetptr="WBDOD07001"> <ttl>Understanding Code Templates</ttl> <xreftext>“Understanding Code Templates”</xreftext> <div element="sect2" href="wbdod10607.htm" number="12.1.1" targetptr="WBDOD10607"> <ttl>Load Code Template</ttl> <xreftext>“Load Code Template”</xreftext> </div> <div element="sect2" href="wbdod10608.htm" number="12.1.2" targetptr="WBDOD10608"> <ttl>Integration Code Template</ttl> <xreftext>“Integration Code Template”</xreftext> </div> <div element="sect2" href="wbdod10609.htm" number="12.1.3" targetptr="WBDOD10609"> <ttl>Control Code Template</ttl> <xreftext>“Control Code Template”</xreftext> </div> <div element="sect2" href="wbdod10610.htm" number="12.1.4" targetptr="WBDOD10610"> <ttl>Change Data Capture Code Template</ttl> <xreftext>“Change Data Capture Code Template”</xreftext> </div> <div element="sect2" href="wbdod10611.htm" number="12.1.5" targetptr="WBDOD10611"> <ttl>Oracle Target Code Template</ttl> <xreftext>“Oracle Target Code Template”</xreftext> </div> <div element="sect2" href="wbdod10612.htm" number="12.1.6" targetptr="WBDOD10612"> <ttl>Function Code Template</ttl> <xreftext>“Function Code Template”</xreftext> </div> <div element="sect2" href="wbdod90771.htm" number="12.1.7" targetptr="WBDOD90771"> <ttl>Predefined CTs</ttl> <xreftext>“Predefined CTs”</xreftext> </div> </div> <div element="sect1" href="wbdod10613.htm" number="12.2" targetptr="WBDOD10613"> <ttl>Using Code Templates</ttl> <xreftext>“Using Code Templates”</xreftext> <div element="sect2" href="wbdod10614.htm" number="12.2.1" targetptr="WBDOD10614"> <ttl>Creating a Code Template Folder</ttl> <xreftext>“Creating a Code Template Folder”</xreftext> </div> <div element="sect2" href="wbdod10615.htm" number="12.2.2" targetptr="WBDOD10615"> <ttl>Creating a Code Template</ttl> <xreftext>“Creating a Code Template”</xreftext> </div> <div element="sect2" href="wbdod90772.htm" number="12.2.3" targetptr="WBDOD90772"> <ttl>Importing a Code Template</ttl> <xreftext>“Importing a Code Template”</xreftext> </div> <div element="sect2" href="knowledge_modules001.htm" number="12.2.4" targetptr=""> <ttl>Tasks in a Code Template</ttl> <xreftext>“Tasks in a Code Template”</xreftext> </div> <div element="sect2" href="wbdod10616.htm" number="12.2.5" targetptr="WBDOD10616"> <ttl>Implementing Code Templates</ttl> <xreftext>“Implementing Code Templates”</xreftext> <div element="sect3" href="wbdod90619.htm" number="12.2.5.1" targetptr="WBDOD90619"> <ttl>Creating a Code Template Mapping</ttl> <xreftext>“Creating a Code Template Mapping”</xreftext> </div> <div element="sect3" href="wbdod90620.htm" number="12.2.5.2" targetptr="WBDOD90620"> <ttl>Specifying an Agent for the Code Template Mapping</ttl> <xreftext>“Specifying an Agent for the Code Template Mapping”</xreftext> </div> <div element="sect3" href="wbdod90621.htm" number="12.2.5.3" targetptr="WBDOD90621"> <ttl>Creating a Mapping Under the Code Template Mapping</ttl> <xreftext>“Creating a Mapping Under the Code Template Mapping”</xreftext> </div> <div element="sect3" href="wbdod90622.htm" number="12.2.5.4" targetptr="WBDOD90622"> <ttl>Using Code Templates in the Mapping</ttl> <xreftext>“Using Code Templates in the Mapping”</xreftext> </div> </div> </div> </div> <div element="chapter" href="web_services.htm" number="13" targetptr="WBDOD10509"> <ttl>Importing and Exporting Data as Web Services</ttl> <xreftext>“Importing and Exporting Data as Web Services”</xreftext> <div element="sect1" href="wbdod90874.htm" number="13.1" targetptr="WBDOD90874"> <ttl>Defining Web Services</ttl> <xreftext>“Defining Web Services”</xreftext> </div> <div element="sect1" href="wbdod10669.htm" number="13.2" targetptr="WBDOD10669"> <ttl>Publishing Functionalities as Web Services</ttl> <xreftext>“Publishing Functionalities as Web Services”</xreftext> <div element="sect2" href="wbdod10670.htm" number="13.2.1" targetptr="WBDOD10670"> <ttl>Creating an Application Server Module</ttl> <xreftext>“Creating an Application Server Module”</xreftext> <div element="sect3" href="f1_webservice_wiz_connection.htm" number="13.2.1.1" targetptr="WBDOD10671"> <ttl>Providing an Application Server Location</ttl> <xreftext>“Providing an Application Server Location”</xreftext> </div> </div> <div element="sect2" href="wbdod10672.htm" number="13.2.2" targetptr="WBDOD10672"> <ttl>Creating a Web Service</ttl> <xreftext>“Creating a Web Service”</xreftext> </div> </div> <div element="sect1" href="wbdod10673.htm" number="13.3" targetptr="WBDOD10673"> <ttl>Importing External Web Services</ttl> <xreftext>“Importing External Web Services”</xreftext> </div> </div> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de