Tag: architecture

Which OWB module is used to design the DW and the ETL processes. This component also includes bridges, integrators, and editors and acts as a point of access to other OWB components.

Which OWB client is used to view metadata, run web reports, perform lineage, and impact analysis on your metadata.

Which client helps you to run reports on the audit and error information captured when you run jobs to load and refresh your ETL processes.

Which OWB client helps you to set up a runtime repository and target schema and maintain the deployment and runtime audit/error information.

How many components are present in OWB architecture?

Which editor defines the source/target modules and editing modules (containers or collection of the DW objects).

Which editor includes the table editor, dimension editor, fact editor etc. that enable you to edit object properties.

Which editor enables you to design and configure how the data gets loaded into the target data warehouse, and is used to design a graphical representation of the relation between the data source objects that are used to populate the data warehouse target objects. The editor provides a set of operators that you can include with the mappings along with standard or custom transformations if required, such as key look, generating sequence etc. It also enables validation and generation of the code used to populate the data warehouse target.

Which enables editing or customizing OWB generated code.

The OWB runtime component includes 2 components, which enables you to view the runtime information of the ETL jobs that were executed using Oracle tools such as Oracle Enterprise manager (OEM).What are they?