Interview Questions.

Q1. What Sources Are Supported Through Oracle Pure Extract?

Oracle Pure Extract supports local get right of entry to to OS/390 structures: 

IMS 

DB2 

VSAM 

Sequential files

Q2. What Is The Oracle Warehouse Builder Repository?

The OWB repository is a server-primarily based, low renovation, effective metadata repository primarily based on the openstandard  Common Warehouse Model (CWM). The repository is the central anxious device of the  Enterprise Business Intelligence answer provided. All layout facts concerning resources,  trformations and warehouses is to be had and may be viewed over the internet, making use of Oracle Portal  technology. This includes lineage and effect evaluation in the course of the warehouse.

Q3. Does Owb Support The Clob And Long Data Types?

No, OWB currently doesn’t help these statistics kinds.

Q4. Which Sources Are Supported By Owb?

OWB supports the subsequent supply environments: 

Oracle RDBMS, versions 7.Three.Four and better 

Flat files (man or woman-delimited, fixed-duration, unmarried-document and multi-file) 

SAP/R3 (2.1.1.34 helps three.1X, 4.0X, four.5X, four.6A, four.6B) 

XML documents (URL, Advanced Queues, documents and many others.) 

Generic Connectivity (ODBC) 

Oracle Trparent Gateways (see next query for a extra distinctive listing)

Q5. What Is Oracle Warehouse Builder?

Oracle Warehouse Builder (OWB) is a framework for advent of extraction, trformation, and loading  scripts for populating an operational statistics store, a statistics mart or a information warehouse. OWB also consists of a  component to design the target records warehouse / facts mart / operational statistics save. The design thing  can be used to create records warehouses designed as superstar schema (along with aggregations / precis degrees  with more than one hierarchies) or warehouses / operational records stores as 0.33 everyday shape.

Q6. Can Owb Generate Artificial Keys?

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

Q7. Does Owb Support Dimensional Targets?

Yes, OWB has a wizard-pushed layout procedure for both dimensions and for facts. Both can be considered and revealed in a diagramming mode.

Q8. Can The Generated Code Be Modified?

Yes, OWB generates code, which may be deployed into the database and it could be deployed into scripts  (text documents). These textual content files may be modified and then deployed to the database with the changes. Note that  these adjustments (if made outside of OWB) aren't stored within the repository, and that troubles with modified  scripts aren't supported via Oracle.

Q9. Does Owb Support 3rd Normal Form Targets?

Yes, OWB allow’s you outline 3rd ordinary form schemas with the wizards guiding you thru the desk creation  system. It also affords a simple wizard to design and outline keys among the tables.

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

No, the OWB integrator answer for SAP isn't 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.

Q11. Which Warehouse Platforms Does Owb Support?

OWB is tuned and build to absolutely utilize the market leading-Oracle database. OWB is a code technology device  and uses the Oracle database as its trformation engine. The client software ought to be hooked up on either a  Windows 2000 or NT 4.0 customer

Q12. Does Owb Support Multiple Source Objects In One Mapping?

Yes, the person can add supply items to a mapping and join those via a joiner. If the tables are related by means of key relationships OWB selections these up automatically and populates the join situation without the user  having to open the joiner and kind this in.

Q13. How Does Oracle Warehouse Builder Facilitate Etl And Warehouse Design?

OWB is a code technology device based totally on a metadata repository, meaning that the design is trlated  internally through OWB, which results inside the technology of code. This code can then be used to create a records  warehouse and the accompanying data trformations.

Q14. Is There A Standard Time Dimension In Owb?

OWB supplies a time size based totally on the Gregorian calendar. The user can decide the levels on this  dimension and pick out from some of pre constructed hierarchies.

Q15. Is Prototyping Supported By Owb?

Due to OWB’s graphical nature, prototypes may be constructed unexpectedly. OWB affords a graphical design device for  logical representations of big name schema and 0.33-ordinary-shape goal databases. It consists of automatic  validation of supply to target mappings, and automated code technology of code. SQL DDL for constructing  target tables, SQL*Loader manage documents for loading information from flat documents, PL/SQL for extraction and  trformation and TCL to enable registration in Oracle Enterprise Manager.

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

OWB offers the person a wizard-pushed design surroundings to create the dimensional warehouse schema. Wizards manual the consumer thru the introduction of dimensions with multiple tiers and hierarchies, the advent  of keys on these degrees, and the linking of those dimensions to the truth tables. OWB offers wizards for all  database items supported in OWB.