Business Intelligence & Data Warehousing

In Web Intelligence multi-query documents, only Dimension objects can be merged across queries. Measures cannot be merged because they represent calculations that would conflict when combined. Detail objects are query-specific and cannot be merged. Dimensions provide the consistent reference points needed to combine data from different queries.

The statement is false because the Central Management Server CAN be stopped from within the Central Configuration Manager, even though it is the principal server. Administrative tools provide the ability to stop and start services for maintenance and updates. The distinction between Configuration Manager and Management Console doesn't prevent stopping the server.

Derived tables reduce maintenance overhead because they eliminate the need to manually create and update physical database summary tables. They provide real-time data analysis by executing queries against current data rather than potentially stale pre-aggregated tables. Option A is incorrect because derived tables can include complex calculations and functions.

In OLAP (Online Analytical Processing), the standard output format is a matrix where dimensions form the rows and columns, and measures (the numerical values) populate the cell values. This is the fundamental structure of a pivot table or cube view. Option A incorrectly places 'Values' in the second position, and Option B misorders the components entirely.

Web Intelligence XI R3 introduced the ability to directly edit SQL queries, giving users more control over data retrieval. Interactive editing capabilities were also added to improve the user experience. Option B is incorrect because dimension merging is possible. Option D is false as .wqy documents are not supported in XI R3.

Detail objects in Business Objects universe design are always attached to dimensions and provide additional descriptive information about those dimensions. They cannot exist as standalone objects (Option C) or attach to measures (Option A). This is fundamental - dimensions are the core objects, and details elaborate on them with extra context.

Slice and Dice operations in Business Objects include Rank, Filter, and Break functions - all are data manipulation tools that allow users to rearrange and analyze report data dynamically. Alert is not a Slice and Dice function because alerts are conditional formatting or notification features, not data manipulation operations.

The correct Business Objects prompt syntax is @Prompt('message', ['type'], [lov], [MONO|MULTI], [FREE|CONSTRAIN]). Option A is correct in showing all parameters but incorrectly omits the @ symbol prefix. Options B and C are missing the 'type' parameter or have incorrect parameter order. The @ symbol is required in Business Objects formula syntax.

Aggregate tables contain pre-calculated summarized data (A is true), which significantly speeds up query execution by avoiding on-the-fly aggregations (B is true). Both statements are correct, making Option C the right answer. Aggregate tables are a fundamental performance optimization technique in universe design for Business Intelligence applications.

Multi-dimensional data models are designed to present business information in a navigable format that users can explore from any angle using combinations of business terms to view KPIs. Option B oversimplifies the purpose, and Option C describes database normalization goals rather than Business Intelligence modeling objectives. The core purpose is enabling flexible business user navigation.

OLAP cache stores query navigation states and results in application server memory, enabling result sharing across users who execute the same query. Cache reads are faster than database reads since data is pre-computed and stored in memory. The cache size depends on server memory, not user desktop memory.

When exporting a universe to the repository, a Secure connection type is required to maintain security credentials and ensure proper authentication. Shared connections don't store individual user credentials needed for repository access.

Aggregation provides OLAP with pre-calculated values, which are summary values computed in advance and stored. This enables faster query response times since calculations don't need to be performed at runtime.

Business Objects XI R3 uses ROLAP (Relational OLAP) architecture, where data remains in relational database tables and multidimensional analysis is performed dynamically. MOLAP uses specialized multidimensional stores, DOLAP is desktop-based, and HOLAP combines both approaches.

Job servers are part of the Processing Tier in BusinessObjects architecture, responsible for executing scheduled jobs and report processing. The Client Tier handles user interaction, Intelligence Tier manages metadata and security, and Data Tier manages database connections.

Metrics are derived from Measure Objects, which contain numerical values that can be aggregated (sum, average, etc.). Dimension Objects provide descriptive context for grouping, while Detail Objects provide additional attributes about dimensions.

OLAP achieves multidimensionality through cube structures that organize data across multiple dimensions (time, geography, product, etc.). The cube structure enables complex and ad-hoc query analysis by allowing users to navigate and slice data along any dimension combination.

Informatica Designer provides Source Analyzer for importing and analyzing source definitions, Transformation Developer for creating reusable transformations, and Mapping Designer for creating data flow mappings. Workflow Manager is a separate tool for workflow design and scheduling.

A session is an object that executes an instance of a mapping in Informatica. It contains runtime configuration information and executes the data transformation logic defined in the mapping, moving data from sources to targets.

Sorter transformation can be both active and passive. It's active when used with 'Distinct' output option (changes row count by removing duplicates), and passive when used only for sorting (maintains row count). Source Qualifier, Router, and Filter are purely active transformations.