Oracle Warehouse Builder (OWB) Interview Questions

Oracle Warehouse Builder (OWB) Interview Questions


What is OWB?


Oracle Warehouse Builder (OWB) is an information integration tool that leverages the Oracle Database to transform data into high-quality information. The Oracle Database is a central component in the Warehouse Builder architecture because the Database hosts the Warehouse Builder repository and the code generated by Warehouse Builder.

What are the major components of warehouse builder?

Oracle Warehouse Builder(OWB) is composed of Design centre,Control center manager,target schema,Warehouse builder repository,Repository browser,control center service.

What is OMB Plus?

OMB plus is a flexible, high-level command line metadata access tool for Oracle
Warehouse Builder. We use OMB Plus to create, modify, delete, and retrieve object metadata in Warehouse Builder design and runtime repositories.

What is the Scriping language used to manipulate OWB?

OMB Plus is a scripting language used to manipulate object and runtime repositories of OWB.OMB Plus is an extension TCL Programming language and hence has variable constructs,looping and control structures.

Where are the SQL scripts located in OWB?

OWB scripts are installed at \owb\rtp\sql and are used for managing deployment jobs,execution jobs,control centers from SQL*PLUS.

How do you launch OMBPlus at Unix Prompt?

We can alunch OMB plus at the unix prompt using
OWB_HOME/owb/bin/unix/OMBPlus.sh

How do you connect to a OWB repository from OMB Plus?

From OMB Plus console enter the following :

OMBCONNECT repos/password@host:port:service_name USE WORKSPACE
wokspace_name

2 Response to "Oracle Warehouse Builder (OWB) Interview Questions"

  1. Hi

    I read this post two times.

    I like it so much, please try to keep posting.

    Let me introduce other material that may be good for our community.

    Source: Warehouse interview questions

    Best regards
    Henry

    Since 1993 The Warehouse Bistro has provided the Auburn-Opelika area a culinary escape from the ordinary. The diverse menu is complemented by nightly. left 4 dead survival warehouse glitch

Post a Comment

Powered by Blogger