41) What a Project contains ?

  1. A Model
  2. Namespaces
  3. Data sources
  4. Parameter maps
  5. Packages
  6. Folders
  7. Query Subject
  8. Query Item
  9. Relation ship

42) What is a Model ?

  • A model in Frame work manager is a business presentation of the structure of the data from one or more databases.

Or

  • A model is a set of related query subjects and other objects.

43) What are Dimensions ?

Dimensions are categories by which summarized data can be viewed.

44) What are Confirmed Dimensions ?

The Dimensions which are reusable and fixed in nature.

45) What are Fact Tables ?

A Fact Table is a table that contains summarized numerical (facts)  and historical data. This Fact Table has a foreign key – primary key relation with a dimension table.

46) What are the types of FACTs ?

The types of Facts are:

  •  Additive Facts:- A Fact which can be summed up for any of the dimension available in the Fact Table.
  •  Semi-Additive Facts:- A Fact which can be summed up to a few dimensions and not for all dimensions and not for all dimensions available in the Fact Table.
  • Non-Additive Fact:- a fact which cannot be summed up for any of the dimensions available in the Fact Table.

47) Define Query ?

A description of the data to be retrieved from a database.

48) Explain about Data Source Query Subject ?

Data Source query subjects contain SQL statements the directly reference data in a single data source. Frame work manager automatically creates a data source query subject for each table and view that you import into model.

49) When the default data source query subject is created ?

During the initial metadata import operation, a default data source query subject is created for each object you select (for example table) and creates the default relationships between query subjects for you automatically.

50) How can you edit the data source query subject ?

 i.     Apply or embed a filter

ii.     Apply or embed a calculation

iii.     Insert a Macro

iv.     Insert a data source reference.

v.     Change the SQL type.

vi.     Change how SQL is generated.

These all are we can find it in “Edit definition window”.

51) What are the types of SQL ?

SQL is the industry language for creating, updating and querying relational data base management system. Types of SQL.

  1. Cognos SQL
  2. Native SQL
  3. Pass-through SQL.

52) Define Cognos SQL ?

By default Cognos Frame work manager uses Cognos SQL to create and edit Query subjects.

Advantages:

  1. Can contain metadata from multiple data sources.
  2. Have fewer database restrictions
  3. Interact more effectively with Cognos applications.

Disadvantages:

            You can not enter nonstandard SQL.

53) Define Native SQL ?

Native SQL is the SQL, the data source uses, such as Oracle SQL, but you cannot uses Native SQL in a query subject that references more than one data source in the project.

Advantages:

  1. Performance is optimized across all related query subjects.
  2. You can use SQL that is specific to your database.

Disadvantages:

  1. You cannot use SQL that the data source does not support for sub queries.
  2. The query subject may not work on different database type.

54) Define Pass-Through SQL ?

Pass-Through SQL lets you use native SQL without any of the restrictions the data source imposes on sub queries.

Advantages:

  1. You can enter any SQL supported by the database.

Disadvantages:

  1. There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source.

55) What are Query Processing Types ?

There are two types of query processing.

  1. Limited Local: The database server does as much of the SQL processing and Execution as possible. However, some reports or report sections use local SQL processing.
  2. Database only: The database server does all the SQL processing and execution with the exception of tasks not supported by the database. An error appears if any reports of report sections require local SQL processing.

56) What is Query Subject ?

  •  A Query Subject maps to the table in the database.
  •  A Query Subject uses an SQL to retrieve the data from the data source.
  •  A Query Subject is also known as Business View.

57) What are the types of Query subjects ?

  1. Default data source query subjects
  2. Model Query Subjects
  3. Stored Query subjects

58) What is a Query Item ?

A query Item maps to columns to the database table. A Query Subject contains Query Items.

59) How can you restrict the tables retrieved by a query ?

            By setting governors we can restrict the tables.

60) What is meant by Governors?

To apply privileges and restrictions for a user class. Governor settings are used to set restrictions on queries by user class, such as

  1. Sorting on non-indexed columns
  2. Outer joins
  3. Suppress duplicates
  4. Cross-product queries
  5. Retrieval of large text items
  6. Number of records
  7. Number of tables
  8. Query execution time