what would you contribute to the dynamic of your suite answers

If yous are looking for Cognos Interview Questions And Answers For Experienced or Freshers, you are in the right place.

Types of SQL Interview Questions

Hither Mindmajix sharing a list of threescore existent-fourth dimension Cognos interview questions and answers, Cognos framework, and Cognos report studio. These questions will help y'all to crack your side by side job interview and acquire a dream career as a Cognos programmer.

Meridian Cognos Interview Questions - Basic Level

Q1) What is the divergence between Tableau Desktop and IBM Cognos?

Tableau Desktop	IBM Cognos
Tableau Desktop provides a characteristic to import and visualize huge data sets, enables users to drill down into the information, and also allows them to brand queries.	IBM Cognos makes information technology easy for users to dynamically explore data relations by transforming data into metadata.
Tableau Desktop makes information technology very like shooting fish in a barrel to employ and makes it very comfortable for users who are non explicitly data experts to explore the necessary data without any bug.	IBM Cognos is a wholesome platform for data experts alone as it is non that easy simple plenty for users with average skills to explore and learn it.
Tableau Desktop works on both Windows and Macintosh OS environments and also has a web-based version	Microstrategy works simply on Windows, Linux, and Macintosh OS environments
Tableau Desktop is targeted to be used in Small, Medium to Larger enterprises	IBM Cognos is targeted to be used in Small-scale, Medium, and Larger enterprises as well.

Q2) What is Dynamic Cube?

Dynamic Cubes are in-memory OLAP cubes that load information directly from relational data sources that are structured in a star or snowflake schema

Introduced equally a new feature from IBM Cognos BI 10.two
The Cognos Dynamic Cubes technology is part of the IBM Cognos BI query stack
The goal of IBM Cognos Dynamic Cubes is to provide quick responses to reports and analyses on large volumes of information.
Enabling high-performance interactive assay over terabytes of data

Q3) Cognos Dynamic Cube solution consists of what elements?

IBM Cognos Dynamic Cube consists of the post-obit elements, they are:

IBM Cognos Cube Designer
IBM Cognos Dynamic Cubes Server
Aggregate Advisor (part of IBM Cognos Dynamic Query Analyzer)

Learn how to apply Cognos, from beginner nuts to advanced techniques, with online video tutorials taught past manufacture experts. Enroll for Free Cognos Training Demo!

when-to-use-cognos-dynamic-cubesQ4) When to apply Cognos Dynamic Cubes?

Data warehouse with star or snowflake schema

A server with adequate memory
A database with approximately 25 meg or more fact table rows

Q5) Cognos Dynamic Cubes support which databases?

Cognos Dynamic Cubes support diverse databases.

Supported Databases (in the current 10.two release) include IBM DB2, IBM Netezza, Microsoft SQL Server, Oracle, Teradata.

Q6) What is the difference between Cognos Dynamic cube, PowerPlay Cube, and Transformer/TM1 cube?

TM1 Cube	PowerPlay Cube	Dynamic Cube
In-memory cube engineering with writeback support	File-based cube technology	Provides extensive in-memory caching for performance
Is optimal for write-back, what-if analysis, planning, and budgeting, or other specialized applications	Interactive analysis experience to a big number of users	Is optimal for read-only reporting and analytics
Star or snowflake data construction is not required	The Data source is an operational or transactional system. Do not require star or snowflake data structure	Star or snowflake schema is required
Assemblage occurs on demand	File-based cube with preaggregation	Supports in-retentivity assemblage

Q7) Where Dynamic Cube resides in Cognos BI Environment?

Dynamic cube are in-memory OLAP containers that reside within the DQM server

Q8) Can you explain the Dynamic Cube Lifecycle in Cognos?

Model and Publish (Warehouse and CM)
Deploy and Manage (Dynamic Cube Server, CM)
Reporting and Analytics (Dynamic cube, Logs)
Optimize (Warehouse, CM, Logs)

Q9) What is Cognos Cube Designer?

Cognos Cube Designer is used to model Dynamic Cubes
Install IBM Cognos Cube Designer in the same location as IBM Cognos Framework Director
We need a JDBC data source connection created in Cognos Administration

Q10) Explain about Cognos Cube Designer modeling workflow?

Offset model your cube definition in Cognos Cube Designer

select the database schema
import the required metadata
define the dimensions and measures
Creating Dynamic cube
Auto-generate cube
Use primary-foreign fundamental relationship to populate dimensions
Manually model the cube
Deploy your dynamic cube to the BI server
Quick-deploy options in Cognos Cube Designer with Publish Option
An pick that is deselected here must exist accomplished manually in FM or in Cognos Connection.

Q11) How do you lot administrate Dynamic Cube?

Assistants tasks include assigning the cube to the QueryService instance, starting it, monitoring its health, and refreshing its contents.

Start/Terminate the Cube
Monitoring Cube
Managing the cache
Scheduling a refresh of the cache

Q12) Explain about Amass Advisor?

Aggregate Advisor is a performance optimization utility

Role of the Dynamic Query Analyzer
Propose database aggregate tables, in-retentiveness amass, or both.
Makes utilize of a cube'south model and statistics
Brand apply of workload log files that are generated from the execution of reports
The expectation is that the dynamic cube is published in the Content Store, can be started successfully, and that reports and analysis run and return correct results.
After a cube is restarted, the aggregates execute the necessary SQL statements to retrieve the summarized values and place the values in its amass cache for subsequent use during query processing.
Run during off-meridian, non-critical business hours

Q13) Explain nigh Aggregate Cache?

Cognos Dynamic Cube supports two types of pre-computed aggregate values:

Stored in in-database tables (in-database amass)
Stored in an in-memory amass cache
Amass Counselor tin can propose a drove of in-retentiveness aggregate
In-retention aggregate does non crave the involvement of DBA
Recommendations are stored in Content Manager and take outcome adjacent fourth dimension a cube is started.
The size of the amass cache is specified in the backdrop of a dynamic cube - Maximum amount of memory to use for the aggregate cache (MB).

Q14) What is Aggregate enshroud size?

Only enough memory that is required to hold the defined aggregates is used.

Example: 90 MB can hold the aggregates for gosldw_sales, and the aggregate cache size is set to 1 GB, only 90 MB of memory is used. Over time, if the underlying fact tables grow, the aggregates are allowed to grow to the specified maximum of i GB.

Should not use more than than 30 GB for the aggregate cache.

Q15) What is Model Durability?

All of the following criteria must be met in order to have what is considered to be a durable model:

In that location is a pattern language created for the model that is not the same every bit the locales the users can choose from. For English, the design language is typically English language(Republic of zimbabwe).
The design language proper noun of all namespaces, query subjects, and query items that are published in a package must never modify subsequently the bundle is initially published. Other language names can change as needed, though.
The structure of a published parcel's namespace(south), query subjects, query items, dimensions, shortcuts, etc, must non modify over fourth dimension. This structure is stored in a specification's definition, forth with the design language's names, so this is the reason these must not change.
In IBM Cognos eight.4.1 the element must exist in model.xml. In IBM Cognos ten the projection level belongings Use Design Locale for Reference ID must be fix to truthful.

Q16) If the model is not durable, so what would you alter to make the model durable?

If the model is not durable, then the following changes must be washed to make the model durable:

If the model does not already have a design language, and so:
- Add together the necessary design linguistic communication to the model and add together information technology to the languages of each packet based on the model. Save and close the model.
- Using an XML or text editor, open the model.xml file, and near the top of the file, change the value of en to en-zw.
For IBM Cognos eight.4.1, insert a blank line into the model.xml file under the simply modified element and add truthful to the new blank line.
For IBM Cognos 10, fix the projection level property Apply Blueprint Locale for Reference ID to a value of true

Q17) What is New Content Durability?

All new content adult with IBM Cognos BI will be durable, as long as the model is durable. Existing non-durable content tin be made durable by appropriately replacing the not-durable components of those specifications with durable components. Existing content is generally fabricated durable over time as the content gets updated for reasons other than immovability

Q18) How do you create security features for cubes?

For creating security features in cubes we tin can use the user course views and dimension views.

Dimension views help in hiding certain information from the cube depending on what view yous are using.

And then we tin use the user class views to the cubes for making that data available for a sure role or group.

Nosotros can besides utilize password protection as another mode of providing security to the cubes.

Q19) What is the size of your cube?

It may accept 300MB; 400MB depends on the position, Optimum size for a cube is upward to 2GB;

Q20) What is the user class in Cognos?

A user class is a group of users who need admission to the same data and have the same admission privileges. The ambassador creates the catalog and user classes. Other people in an organization may besides create and maintain user classes for the employees in their own department or area.

You can add user classes to a catalog if y'all created the catalog or you are working with a personal copy of a distributed itemize and your ambassador gave you lot the privilege to add and modify user classes.

Cognos Framework Manager Interview Questions

Q21) What is the Framework Manager?

Framework Manager is a tool that allows you to brand data sources known for use within the various Cognos suites and allows you to add together additional logic and details. Within a logical Cognos architecture, a Framework Manager model contains the logic and information required for 1 of the Cognos tools to utilise a data source.

Q22) Explicate IBM Cognos Framework Manager Model?

IBM Cognos Framework Manager is a metadata modeling tool that drives query generation for IBM Cognos software. A model is a collection of metadata that includes physical information and business information for ane or more information sources. IBM Cognos software enables performance management on normalized and denormalized relational data sources and a variety of OLAP data sources.

Q22) What are the layers bachelor in the Framework Manager Model?

The Framework Manager model consists of three layers:

Database layer
Logical Layer
Dimensional layer

Q23) What is the IBM Cognos Framework Manager model database layer?

The concrete, or database, the layer contains a database query subject area for every table in the physical information model. The database layer also contains alias shortcuts, which behave as if they were a copy of the original object with completely independent beliefs.

Q24) What is the IBM Cognos Framework Manager model logical layer?

The logical layer contains query subjects that depict data from the database query subjects and present it in a more consumable format.

Q25) What is the IBM Cognos Framework Director model dimensional layer?

The dimensional layer contains the hierarchies and measure dimensions for publication to a package. Each dimension in the logical layer has a dimension in the dimensional layer with ane or more than hierarchies defined. The hierarchies usually include the caption field twice, once equally a explanation for the level, once equally an aspect that tin be used in written report filters. All hierarchies are sorted.

Q26) What is the IBM Cognos Framework Managing director model security?

No security is divers for the IBM Cognos Framework Manager model other than the provision for filtering by the tenant_id parameter on the physical layer. These query subject filters can be converted to security filters that are based on user IDs, assuasive multi-tenant access to one database.

Q27) What is Query mode?

The IBM Predictive Maintenance and Quality reports use IBM Cognos Compatible Query Way, which is the supported mode for all of the reports.

Q28) What is IBM Predictive Maintenance and Quality?

With IBM Predictive Maintenance and Quality, you can monitor, analyze, and written report on information that is gathered from devices. In addition, recommendations for deportment tin be generated by Predictive Maintenance and Quality.

IBM Predictive Maintenance and Quality is an integrated solution that yous can use to perform the following tasks:
Predict the failure of an instrumented asset so that you tin can forestall costly unexpected downtime.
Make adjustments to predictive maintenance schedules and tasks to reduce repair costs and minimize downtime.
Quickly mine maintenance logs to decide the about constructive repair procedures and maintenance cycles.
Identify the root cause of asset failure faster so that you can take corrective actions.
Identify quality and reliability issues definitively and
in a timely way.

Q29) What is Orchestration in IBM Predictive Maintenance and Quality?

The orchestration is the process that ties activities in IBM Predictive Maintenance and Quality together.

Message flows: Orchestration is achieved with message flows in IBM Integration Motorcoach.

Instance of an orchestration XML file: An case file, inspection.xml, demonstrates the purpose and structure of an orchestration file.

Generic batch orchestration: Generic batch orchestration provides capabilities to run a scheduler menstruation and invoke whatever IBM SPSS batch job past taking inputs from a configurable XML file instead of developing carve up message flows for a specific utilize case.

Q30) Can you explain about Message Flows?

The orchestration is achieved with message flows in IBM Integration Bus.

The post-obit activities tin can exist tied together:

Acquiring and storing data
Aggregating data
Running predictive models
Feeding data back to external systems or starting external processes

Bulletin flows are supplied with IBM Predictive Maintenance and Quality and must exist customized with IBM Integration Bus. The message flows are organized into the following applications:

PMQEventLoad
PMQMasterDataLoad
PMQMaximoOutboundIntegration
PMQMaintenance
PMQModelTraining
PMQQEWSInspection
PMQQEWSIntegration
PMQQEWSWarranty
PMQTopNFailure

Cognos Interview Questions For Experienced

Q31) How Framework Director Uses Cardinality?

Cardinality is used by the query engine to:

Identify query subjects that behave every bit facts and dimensions

1..n cardinality implies fact information on the n side and dimension data on the 1 side

Avoid double counting fact data

Support loop joins in star schema models

Cardinality is applied in the context of a query

Query subjects may be facts or dimensions depending on the other query subjects included in the query

Q32) What are Determinants?

Determinants Feature commencement introduced in Cognos 8 used to provide control over granularity when aggregating

Reflects granularity by identifying groups or subsets of data in a query field of study
Used to ensure that repeating data is aggregated correctly
Are set during import based on unique primal and index information in a database
Used by Framework Managing director to determine levels in default hierarchy when auto-generating regular dimensions from query subjects

Q33) When and how should you lot use Determinants?

When exercise I need to employ determinants:

When dimensions connect to fact tables at levels of granularity that take repeating keys
When at that place is a need to count or perform aggregate functions on a primal or attribute that is repeated
To avoid generating a 'distinct' clause on distinct keys

Q34) What is Modle Advisor?

Use Model Advisor – Check early and often

Model Counselor is a useful tool for detecting common modeling problems, Cardinality problems, Potential join path conflicts, Incorrect determinants. Easy to configure to check as for equally much or as fiddling as desired, Run after import to bank check for areas that demand farther investigation, Run again periodically to identify potential issues as you piece of work, Direct links to the problem area, and Assistance.

Q35) What is Dimensional Modeling for Report and Analysis?

Dimensionally modeled relational (DMR) constructs in Classic Query Manner

Logical dimensional layer over pinnacle of a relational model
Single mensurate dimension and one or multiple regular dimensions
Enables drill-upwardly/drill-downward analysis in the studios
Dimensional layer can be practical over any star schema model
Not a requirement that the underlying data source exist a star schema design
Dimensions and measure dimensions are constructed from model query subjects or database query subjects
At runtime, queries are run to spin a virtual cube on disk to simulate the OLAP style analysis capabilities

Q36) What are Regular Dimensions?

Regular dimensions created from model query subjects or database query subjects

Define hierarchies to organize levels and define drill paths
You tin specify multiple hierarchies in a unmarried dimension
Define levels, business keys, and caption
Create from scratch using Dimension Definition dialog
Use "Merge in New Regular Dimension" or "Convert to Regular Dimension" capabilities
The dimension will exist auto-generated based on the query subject definition
Default bureaucracy created
Levels derived from determinants gear up
May demand to be adapted based on requirements

Q37) What is Mensurate Dimension?

Create measure dimension

Collection of facts
Create measure dimension using Dimension Definition dialog or "Convert to Measure out Dimension" capability
Add existing measures or create calculations
Ascertain scope relationships
Dictates level at which measures are bachelor for reporting
Telescopic human relationship will be detected by the Framework Manager using the underlying bring together paths between query subjects and fact query bailiwick
Telescopic relationships can be defined and reviewed in the Dimension Map

Q38) What is Query Generation?

By default, Framework Manager will utilise Cognos SQL to create Query Subjects

In Classic Query Mode, at runtime, native SQL optimized for the data source is generated and passed downwardly through to the data source

RQP (Relational Query Planner) plans the query and and then passes information technology off to UDA (Universal Data Access)
UDA component has a series of gateway files that control SQL generation for specific RDBMS (DB2, Oracle, MS SQL Server, etc)
UDA generates the native SQL and executes it confronting the RDBMS

Copy of the query engine local in the Framework Manager install

Used for importing metadata, testing query subject, generating SQL, and validation of expressions

In Dynamic Query Mode, requests are sent to the Query Service for processing

No query service running locally on the FM side

Framework Managing director volition include passing the necessary elements in the model to Query Service on the server

Result set and generated SQL for the query will be role of the response back to FM.
This is the case testing objects and evaluating expressions

Q39) What is the SQL Generation?

Apply minimized SQL when possible

Certain conditions will trigger every bit view SQL and override this setting:

Determinants on a model query subject
Relationships betwixt model query subjects
Filters, macros, or calculations in data source query subjects

"Equally view" SQL not always bad

Sometimes required to force certain behaviors
Can exist necessary to ensure predictable query results
Know your requirements and your data

Q40) What is Dynamic Query Mode (DQM)?

A new Dynamic Query Processing Mode (DQM) to the existing query service designed to improve query functioning.

Enhanced Java-based query execution mode introduced in 10.i to back up select OLAP sources
Leverages JDBC admission to supported data sources
- Back up has been extended in 10.1.1 to include the following relational sources
DB2, Netezza, Teradata, Oracle, MS SQL Server
Can exist used with a 64-fleck report server included in 10.1.1 to enable administrators to better leverage retentivity
Has robust caching capabilities to aid improve query operation
- In-memory caching of the query plan and query results
- Security aware
SQL generation optimization for relational sources
A new implementation to support dimensional modeling of relational data sources
- OLAP over Relational
Non the same implementation as DMR incompatible mode
Simpler, more efficient queries than DMR
Null suppression optimizations
Master-particular optimizations available in reports
- Treats OLAP over Relational as a true OLAP source
Enables study authors to fully leverage member functions and OLAP manner reporting techniques
- Dramatic performance benefits available past leveraging caching capabilities

Q41) Explain about working with Dynamic Query Mode?

Framework Manager 1.10, viii.10, and x.x includes a full copy of the data admission stack

Used for import, testing, and evaluating query subjects, relationships, etc.
Framework Managing director machine requires DB client software installed

With the introduction of 10.1.one, Framework Manager enables users to work in Dynamic Query mode or Compatible mode

Tin enable DQM at the projection level or package level

Working in dynamic mode volition leverage the always leverage the query service on the server

Import, testing, and evaluation of objects

The uniform mode will proceed to leverage the local query components

CQE, UDA, etc.

New metadata import mechanism available for DQM

JDBC import that leverages RELMD service
Zero local required in an FM surroundings
Dramatic comeback in functioning for very large imports

A new mechanism to test objects and evaluate expressions

Client-server type model
Framework Manager will transport a request to query the service
Generated query and consequence set volition be returned

On-demand evaluation of expressions in the editor

Option to turn off "per-click" evaluation in the expression editor

Tin can piece of work in compatible fashion and enable dynamic query mode for packages

Tin can enable dynamic mode on a packet by package basis
The machinery in place to ensure data sources are enabled

Can switch an existing model to the dynamic fashion

All objects in the model will be evaluated by query service
For existing models, more efficient to enable dynamic mode on a package basis to evaluate

Q42) Working in Dynamic Fashion – OLAP over Relational?

Some differences between DMR and OLAP over Relational

OLAP over Relational much closer to truthful OLAP feel

Fellow member ordering

DQM provides 2 mechanisms for member ordering

Natural ordering

Ascending order by member caption
Not consequent in compatible mode (varies by query/data source)

Sort specification

Pick available in Framework Manager to explicitly gear up
Set for metadata tree in studios
Ready for data values returned

Null suppression capabilities

Truthful OLAP style null suppression available
Controls available at a studio level

Cipher handling in the calculation

Configuration bachelor on the server to have 0 substituted for nulls for mathematical calculations

Q43) What is the package in Cognos?

IBM Cognos Package or Report. Yous tin can import query items, and the associated filters and prompts, from IBM Cognos packages and reports. You lot exercise this by choosing the Package or Report data source type and browsing and selecting from the available metadata.

Q44) What is Impromptu in Cognos?

Cognos Impromptu is an intuitive, user-friendly arrangement that enables not-technical personnel to quickly and easily design and distribute business organisation intelligence reports.

Q45) What is the utilize of Cognos tm1?

IBM Cognos TM1 (formerly Applix TM1, formerly Sniper TM/1) is enterprise planning software used to implement collaborative planning, budgeting, and forecasting solutions, as well as analytical and reporting applications.

Q46) What is a Cognos Controller?

IBM Cognos Controller is part of an integrated Financial Close Management (FCM) solution, built on an efficient, purpose-built platform. It helps you lot deliver complete financial results, create financial and management reports, and provide the CFO with an enterprise view of key ratios and metrics.

Q47) What is Cognos Planning?

Flexible enterprise software for planning, budgeting, forecasting, and analysis. IBM Cognos Planning enables you to develop plans, budgets, and forecasts faster and more efficiently. Cognos Planning lets yous create, compare, and evaluate business scenarios.

Q48) What is tm1 Architect?

IBM Cognos TM1 is a solution with a client-server architecture and TM1 Architect is ane of the standard TM1 customer components that can connect to the TM1 server. The fundamental components of TM1 are TM1 Architect, TM1 Perspectives, TM1 Web, and Turbo Integrator.

Q49) What is the tm1 perspective?

TM1 Perspectives is a standard TM1 standalone application and needs Microsoft Excel to run. Information technology uses Cube Viewer features while taking reward of MS Excel functionality via an add-in for Excel.

Q50) What is tm1 Web?

IBM Cognos TM1 Spider web uses a multi-tiered architecture that enables users to admission and collaborate with Cognos TM1 data using any supported web browser. The IBM Cognos TM1 Web multi-tiered architecture includes web client, spider web application server, and data component tiers.

Cognos Written report Studio Interview Questions For Experienced

Q51) What is the extension of the framework manager project file?

The extension for the framework manager project file is a shop in the file system with extension .cpf ( Cognos Project File )

Q52) What is the difference betwixt the model and package in Cognos?

A model serves every bit an insulating layer between IBM Cognos BI reporting users and the database. Packages are model subsets that ensure users are provided with data appropriate for the reporting they demand to do, and that the data is structured in ways that brand sense from a business perspective.

Creating models and publishing packages are tasks that should exist planned carefully. Models and packages that are well-designed from the start ensure that user requirements are met, data is secure, and your IBM Cognos BI application tin can be easily administered.

To understand the modeling and packaging process, users can study the sample models, packages, and reports provided with IBM Cognos BI. For information about setting upwards the samples, see the IBM Cognos Administration and Security Guide.

For IBM Cognos BI reporting, models and packages are created using Framework Managing director. The following topics provide an overview. For more than data, run across the IBM Cognos Framework Manager User Guide.

Q53) What are dissimilar blazon of securities can we apply in framework manager?

In IBM Cognos Framework Manager, security is a style of restricting admission to metadata and data across IBM Cognos products.

There are dissimilar types of security in Framework Manager:

Information Security: You create a security filter and apply it to a specific query subject. The filter controls the data that is shown to your users when they set upwards their reports.
Object Security: You secure an object directly by assuasive users access to the object, denying users access to the object, or keeping information technology hidden from all users.
Packet Security: You apply security to a package and place who has access to that package.

Q54) What is looping and how to avert it in framework managing director?

Loop joins in the model are typically a source of unpredictable behavior. This does not include star schema loop joins.

When cardinality clearly identifies facts and dimensions, IBM Cognos software can automatically resolve loop joins that are acquired past star schema information when you accept multiple fact tables joined to a common fix of dimension tables.

In the case of loop joins, ambiguously defined query subjects are the primary sign of problems. When query subjects are ambiguously defined and are part of a loop bring together, the joins used in a given query are decided based on a number of factors, such as the location of relationships, the number of segments in join paths, and, if all else is equal, the alphabetically kickoff join path. This creates defoliation for your users and nosotros recommend that you lot model to clearly place the join paths.

Q55) What is the difference between star schema and snowflake schema in Cognos?

Star and snowflake schema designs are mechanisms to separate facts and dimensions into dissever tables. Snowflake schemas further divide the different levels of a hierarchy into divide tables.

Star schemas - A star schema is a type of relational database schema that is composed of a single, central fact table surrounded by dimension tables.

Snowflake schemas - The snowflake schema, sometimes called snowflake join schema consists of 1 Fact table continued to many dimension tables, which can be continued to other dimension tables.

Q56) What is warehouse cubing?

IBM DB2 Warehouse Cubing Services is designed to provide a multidimensional view of information stored in a relational database. With Cubing Services, you tin can create, edit, import, export, and deploy cube models over the relational warehouse schema. Cubing Services also provides optimization techniques to dramatically improve the performance of OLAP queries, a core component of data warehousing and analytics.

Q57) What are the Fact Tables?

A fact table is a table in a star or snowflake schema that stores facts that measure the business, such as sales, cost of goods, or profit. Fact tables also incorporate strange keys to the dimension tables. These strange keys relate each row of data in the fact table to its respective dimensions and levels.

Cubing Services also supports fact tables that are logical, significant that the fact tabular array of a facts object in a cube model can exist a view.

Q58) What are the Dimension tables?

A dimension table is a table in a star or snowflake schema that stores attributes that describe aspects of a dimension. For instance, a fourth dimension table stores the various aspects of time such every bit twelvemonth, quarter, month, and solar day. A foreign primal of a fact table references the principal key in a dimension tabular array in a many-to-one relationship.

Q59) What are the cube models?

The DB2 Warehouse cube model represents a logical star schema or snowflake schema and groups relevant dimension objects around a central facts object.

Each dimension can have multiple hierarchies. The structural information nigh how to join the tables that are used by the facts object and dimensions is referenced by the cube model. Besides stored in the cube model is enough information to construct SQL queries and to call up OLAP data. Other reporting and OLAP tools that understand the cube model and that can display multiple views of a specific dimension can benefit from using the cube model.

Q60) What is a dimensional schema?

A database is comprised of one or more tables, and the relationships amongst all the tables in the database are collectively called the database schema. Although there are many different schema designs, databases used for querying historical information are ordinarily set up with dimensional schema design, typically a star schema or a snowflake schema.

In that location are many historical and practical reasons for dimensional schemas, simply the reason for their growth in popularity for determination support relational databases is driven by two main benefits:

The ability to form queries that answer business questions. Typically, a query calculates some measure of functioning over several business dimensions.
The necessity to course these queries in the SQL linguistic communication, used past nigh RDBMS vendors.

ruckmannoureciand.blogspot.com

Source: https://mindmajix.com/cognos-interview-questions-answers