Are you expertise in IBM Cognos Framework Manager? Looking for the best career opportunity in IBM cognos framework. Search and apply for the best jobs posted on wisdom jobs by top employers. Cognos framework manager used to create business model of metadata derived from one or more data sources. Framework manager jobs are available in various locations such as Hyderabad, Mumbai, and Bangalore, Pune, Delhi and other top cities of India. If you are sound in Cognos 11, Cognos dashboards, Query Studio & Framework Manager (metadata modelling) and business intelligence / warehouse context will be an added advantage. Have a look at wisdom jobs Cognos Framework Manager job interview questions and answers for better job winning chances. Search and apply for the best suitable jobs on wisdom jobs.
Question 1. What Is Framework Manager?
Answer :
Frame Work Manager is windows based metadata modeling tool for Cognos studios.
Question 2. Why We Need Framework Manager?
Answer :
Question 3. How A Project Appears In A Frame Work Manager?
Answer :
A frame work manager project appears as a folder that contains a project file (.cpf) and the specific XML files that define the project.
Question 4. What Are The Building Blocks In Framework Manager?
Answer :
The Query subjects are called Building Blocks in Framework Manager.
Question 5. What Are Phases The Workflow Process Consists In Framework Manager?
Answer :
The workflow process consists of the following phases:
Question 6. How You Set The Security Framework Manager?
Answer :
To set the security you have to set as:
Question 7. Define Name Space?
Answer :
Question 8. Can You Delete Cognos Namespace?
Answer :
No, we cannot delete Cognos namespace
Question 9. What Is The Cognos Namespace? And What It Contains?
Answer :
The Cognos namespace is the Cognos built-in namespace
It contains Cognos objects:
Question 10. What Are The Groups And Roles?
Answer :
Groups and roles represent collections of users that perform similar tasks.
Answer :
A Folder is used to organize the Query Subjects.
Question 12. Define Relationship?
Answer :
A Relationship is a connection that explains how the data in one Query Subject related to data in other Query Subjects.
Question 13. What Is A Package?
Answer :
A container of model or set of models. Modelers create packages in Framework Manager to publish models to the Cognos connection.
Question 14. What Is Physical Layer?
Answer :
The Physical layer provides the physical query layer and is made up primarily of data source and stored procedure query subjects. It acts as the foundation for the presentation layer.
Question 15. What Is Presentation Layer?
Answer :
The Presentation layer makes it easier for report authors to find and understand their data. The Presentation layer is made up primarily of model query subjects that you create.
Question 16. Define Function Set?
Answer :
A function set is a collection of vendor specific database.
The Expression editor lists the function sets for all available vendors. However, you can restrict the function sets, so that it lists only the vendors that you want to use in your project.
Question 17. What Is A Metadata?
Answer :
Data about data is called as Metadata. The Metadata contains the definition of a data.
Question 18. What Is A Project?
Answer :
When we work with a framework manager you work in a project.
Project is a set of metadata organized for Report Authors according to the Business rules and Model
A Project created appears as folder, which contains following files.
The files in the folder are unique to that Project.
Answer :
To transfer all or part of a Framework Manager model to the Cognos connection, so that report authors can use it.
Question 20. What A Project Contains?
Answer :
Answer :
A model in Frame work manager is a business presentation of the structure of the data from one or more databases.
Question 22. What Are Dimensions?
Answer :
Dimensions are categories by which summarized data can be viewed.
Question 23. What Are Conformed Dimensions?
Answer :
The Dimensions which are removable and fixed in nature.
Question 24. What Are Fact Tables?
Answer :
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.
Question 25. What Are The Types Of Facts?
Answer :
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.
Answer :
A description of the data to be retrieved from a database.
Question 27. Explain About Data Source Query Subject?
Answer :
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.
Question 28. When The Default Data Source Query Subject Is Created?
Answer :
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.
Question 29. How Can You Edit The Data Source Query Subject?
Answer :
These all are we can find it in “Edit definition window”.
Question 30. What Are The Types Of Sql?
Answer :
SQL is the industry language for creating, updating and querying relational database management system. Types of SQL.
Question 31. Define Cognos Sql?
Answer :
By default Cognos Frame work manager uses Cognos SQL to create and edit Query subjects.
Advantages:
Disadvantages:
You can not enter nonstandard SQL.
Question 32. Define Native Sql?
Answer :
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:
Disadvantages:
Question 33. Define Pass-through Sql?
Answer :
Pass-Through SQL lets you use native SQL without any of the restrictions the data source imposes on sub queries.
Advantages:
You can enter any SQL supported by the database.
Disadvantages:
There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source.
Question 34. What Are Query Processing Types?
Answer :
There are two types of query processing:
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.
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.
Question 35. What Is Query Subject?
Answer :
Question 36. What Are The Types Of Query Subjects?
Answer :
Question 37. What Is A Query Item?
Answer :
A query Item maps to columns to the database table. A Query Subject contains Query Items.
Question 38. How Can You Restrict The Tables Retrieved By A Query?
Answer :
By setting governors we can restrict the tables.
Question 39. What Is Meant By Governors?
Answer :
To apply privileges and restrictions for a user class. Governor settings are used to set restrictions on queries by user class, such as
Question 40. What Is A User Class?
Answer :
A defined group of users with the same data access needs privileges and restrictions.
Question 41. What Is Scrubbing At Project Level?
Answer :
According to the report requirements derive the new Items with the help of existing Query Items. This process is known as Scrubbing at Project level.
Question 42. How Can You Add The Calculated Data To A Report?
Answer :
Question 43. What Are The Sources To Create New Query Subjects?
Answer :
A new Query Subject can be created from the following sources:
Question 44. What Is Multi Database Access In Cognos ?
Answer :
In Cognos "Framework Manager" a Project can be created from multiple databases. The databases can be either homogeneous or hetrogeneous.
Question 45. What Are Parameter Maps?
Answer :
Question 46. What Is The Default Formats Of Reports?
Answer :
HTML, PDF, CSV, and XML.
Question 47. What Are The Different Ways To Modify Multi Lingual Metadata?
Answer :
Answer :
A Macro is a run time object, which uses the parameter maps and session parameters in developing the conditional query subjects.
Question 49. What Is Usage Property? And What Are Different Settings To Set Usage Property?
Answer :
It identifies the intended use for the data represented by each query item.
It determines the aggregation rules of query items and calculations.
The different usage property settings are:
Question 50. What Are The Types Of Filters In Framework Manager?
Answer :
In framework manager we can create two types of filters.
Question 51. Define Model Filter?
Answer :
Question 52. Define Data Restriction?
Answer :
A filter is a condition, which restricts the amount of data displayed in the report.
Question 53. What Is Condition?
Answer :
An expression that yields a Boolean value. Conditions are used in query expressions, query filters, and Boolean report variables that can be used for conditional formatting, styles, data sources, layouts and blocks.
Question 54. What Are The Types Of Filters In Report Studio?
Answer :
In the report studio we can find two types of filters:
1. Tabular Filters:- These filters are two types
2. Grouped Filter
Answer :
Question 56. What Is Alias Table?
Answer :
An alternative name for a table generally used in self joins.
Question 57. What Are The Uses Of Alias Table?
Answer :
The uses of Alias Table are:
Question 58. What Is Associated Data Item?
Answer :
A Data Item linked to the group data item. Associated data item suppress duplicate data values but do not generate a control break. The associated column displays only one data values for the group with which it is associated.
Question 59. What Is Automatic Association?
Answer :
The group association of a newly created summary. The location of the group where you create the summary determines its automatic association.
Question 60. What Is An Ambiguous Relationship?
Answer :
An ambiguous relationship is where there are multiple relationship paths between one or more query subjects leaving multiple options for how to write a query.
Question 61. What Is A Join And Types Of Joins?
Answer :
A Join identifies the columns from one table that are used to link to another table.
A Join is commonly formed by a foreign key definition within the database.
Types of Joins:-
Question 62. What Is A Dimension?
Answer :
A broad grouping of descriptive data about a major aspect of a business, such as products, dates, or markets. Each dimension includes different levels of members in one or more hierarchies, and an optional set of calculated members.
Question 63. What Is A Conformed Dimension?
Answer :
If a Dimension is connected to multiple fact tables then it is called as Conformed Dimension.
Question 64. What Is A Junk Dimension?
Answer :
A randomly used dimension is Junk Dimension
Question 65. Define Surrogate Key?
Answer :
It has system-generated artificial primary key values, which allows to maintain historical records in the Data Warehouse more effectively.
Question 66. What Are The User Interface Components
Answer :
Cognos Framework Manager Related Tutorials |
|
---|---|
IBM Cognos Tutorial | Software Development Lifecycle (SDLC) Tutorial |
Unix/Linux Tutorial | Adaptive software development Tutorial |
Cognos Framework Manager Related Practice Tests |
---|
IBM Cognos Practice Tests |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.