Oracle Warehouse Builder Interview Questions & Answers

Oracle Warehouse Builder Interview Questions

Oracle warehouse builder is an ETL tool to provide graphical environment to create data integration process in the BI systems. The job seeker or the oracle software have to gain knowledge on the aspects like architectural details of the warehouse, tools and components, usage of the command line and much more. When you are interested to get job as oracle warehouse builder, it is important to go through portal. Oracle warehouse builder interview questions and answers will let you go through basic knowledge as well as deep knowledge job interview questions and answers to polish your skill set to crack the interview in your desired company. The interview questions framed here are in the descending order of basic questions to expert questions so, make sure you go through all the Oracle warehouse builder interview questions and answers to brush your skill set up.

Oracle Warehouse Builder Interview Questions And Answers

Oracle Warehouse Builder Interview Questions
    1. Question 1. Can Owb Generate Artificial Keys?

      Answer :

      Yes, depending on the implementation language, OWB uses either sequences (PL/SQL implementation) or a data generator (SQL*Loader implementation) to product these artificial keys.

    2. Question 2. Can The Generated Code Be Modified?

      Answer :

      Yes, OWB generates code, which can be deployed into the database and it can be deployed into scripts  (text files). These text files can be modified and then deployed to the database with the changes. Note that  these changes (if made outside of OWB) are not stored in the repository, and that problems with modified  scripts are not supported by Oracle.

    3. Question 3. Does Owb Support Multiple Source Objects In One Mapping?

      Answer :

      Yes, the user can add source objects to a mapping and join these via a joiner. If the tables are connected by key relationships OWB picks these up automatically and populates the join condition without the user  having to open the joiner and type this in.

    4. Question 4. Is There A Standard Time Dimension In Owb?

      Answer :

      OWB delivers a time dimension based on the Gregorian calendar. The user can determine the levels in this  dimension and choose from a number of pre built hierarchies.

    5. Question 5. Does Owb Support 3rd Normal Form Targets?

      Answer :

      Yes, OWB let’s you define 3rd normal form schemas with the wizards guiding you through the table creation  process. It also provides a simple wizard to design and define keys between the tables.

    6. Question 6. Does Owb Support Dimensional Targets?

      Answer :

      Yes, OWB has a wizard-driven design process for both dimensions and for facts. Both can be viewed and printed in a diagramming mode.

    7. Question 7. Which Warehouse Platforms Does Owb Support?

      Answer :

      OWB is tuned and build to fully utilize the market leading-Oracle database. OWB is a code generation tool  and uses the Oracle database as its transformation engine. The client software must be installed on either a  Windows 2000 or NT 4.0 client

    8. Question 8. Does The Sap Installation Have To Be On An Oracle Database?

      Answer :

      No, the OWB integrator solution for SAP is not depended on the underlying database. SAP installed on a non Oracle database (Informix, DB2, SQL Server or Sybase) can be accessed with the OWB SAP integrator.

    9. Question 9. Does Owb Support The Clob And Long Data Types?

      Answer :

      No, OWB currently doesn’t support these data types.

    10. Question 10. What Sources Are Supported Through Oracle Pure Extract?

      Answer :

      Oracle Pure Extract supports native access to OS/390 platforms: 

      • IMS 
      • DB2 
      • VSAM 
      • Sequential files

    11. Question 11. Which Sources Are Supported By Owb?

      Answer :

      OWB supports the following source environments: 

      • Oracle RDBMS, versions 7.3.4 and higher 
      • Flat files (character-delimited, fixed-length, single-record and multi-record) 
      • SAP/R3 ( supports 3.1X, 4.0X, 4.5X, 4.6A, 4.6B) 
      • XML documents (URL, Advanced Queues, documents etc.) 
      • Generic Connectivity (ODBC) 
      • Oracle Transparent Gateways (see next question for a more detailed list)

    12. Question 12. Is Prototyping Supported By Owb?

      Answer :

      Due to OWB’s graphical nature, prototypes can be built rapidly. OWB provides a graphical design tool for  logical representations of star schema and third-normal-form target databases. It contains automated  validation of source to target mappings, and automated code generation of code. SQL DDL for building  target tables, SQL*Loader control files for loading data from flat files, PL/SQL for extraction and  transformation and TCL to enable registration in Oracle Enterprise Manager.

    13. Question 13. How Easy Is It To Create The Warehouse Schema With Owb?

      Answer :

      OWB gives the user a wizard-driven design environment to create the dimensional warehouse schema. Wizards guide the user through the creation of dimensions with multiple levels and hierarchies, the creation  of keys on these levels, and the linking of these dimensions to the fact tables. OWB provides wizards for all  database objects supported in OWB.

    14. Question 14. How Does Oracle Warehouse Builder Facilitate Etl And Warehouse Design?

      Answer :

      OWB is a code generation tool based on a metadata repository, meaning that the design is translated  internally by OWB, which results in the generation of code. This code can then be used to create a data  warehouse and the accompanying data transformations.

    15. Question 15. What Is The Oracle Warehouse Builder Repository?

      Answer :

      The OWB repository is a server-based, low maintenance, powerful metadata repository based on the openstandard  Common Warehouse Model (CWM). The repository is the central nervous system of the  Enterprise Business Intelligence solution provided. All design information regarding sources,  transformations and warehouses is available and can be viewed over the web, utilizing Oracle Portal  technology. This includes lineage and impact analysis throughout the warehouse.

    16. Question 16. What Is Oracle Warehouse Builder?

      Answer :

      Oracle Warehouse Builder (OWB) is a framework for creation of extraction, transformation, and loading  scripts for populating an operational data store, a data mart or a data warehouse. OWB also includes a  component to design the target data warehouse / data mart / operational data store. The design component  can be used to create data warehouses designed as star schema (including aggregations / summary levels  with multiple hierarchies) or warehouses / operational data stores as third normal form.

Oracle Warehouse Builder Related Interview Questions

Oracle Warehouse Builder Related Practice Tests

Popular Interview Questions

All Interview Questions

Oracle Warehouse Builder Practice Test

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status