{"iq":[{"id":"1",
"q":"What is a Data Warehouse?",
"answer":"A Data Warehouse is a collection of data marts representing historical data from different operation data sources (OLTP). The data from these OLTP are structured and optimized for querying and analysis in a Data Warehouse. "
},
{"id":"2",
"q":"What is Cognos Reporting tool? ",
"answer":"Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse. "
},
{"id":"3",
"q":"What is Cognos Connection?",
"answer":"It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data."
},
{"id":"4",
"q":"What is Report item?",
"answer":"Report item is nothing but a query item when it is drag and drop into the work area. "
},
{"id":"5",
"q":"What is query subject?",
"answer":"A query subject is the basic building block in Framework Manager. A query subject is a set of query items that have an inherent relationship."
},
{"id":"6",
"q":"What is set to be Cardinality?",
"answer":"Cardinality is defined as relationships between the tables. Following are relationship formed between the tables.\n\nOne to One\n\nOne to Many\n\nMany to Many\n\nMany to One "
},
{"id":"7",
"q":" What is defined as Data mining?",
"answer":" Data mining is the process of getting hidden trends from a data ware house. "
},
{"id":"8",
"q":"What are all the different types of prompt in Cognos?",
"answer":"Value prompt\n\nText Prompt\n\nDate prompt\n\nTime prompt\n\nDate and time prompt"
},
{"id":"9",
"q":"What is situated to be Cardinality? ",
"answer":"Cardinality is characterized as connections between the tables. Taking after are relationship shaped between the tables.\n\n1. Balanced\n\n2. One to Many\n\n3. Many to Many\n\n4. Many to One"
},
{"id":"10",
"q":"What are the components of Report Net?",
"answer":"Taking after are the components of Report Net:\n\n1. Framework manager\n\n2. Cognos connection\n\n3. Query Studio\n\n4. Report Studio"
},
{"id":"11",
"q":"What do you mean by Drill Through report?",
"answer":"Drill through reporting is utilized to connection starting with one report then onto the next report.\n\nIt has guardian and tyke relationship between the reports."
},
{"id":"12",
"q":" Notice the distinction in the middle of “macros” and ‘brief’?",
"answer":"Large scale is utilized to run situated of directions to execute the report however incite give an approach to change the report alterably."
},
{"id":"13",
"q":"What is a Snapshot?",
"answer":"A preview is made to duplicate the definite information that is identified with current report and contrast and another report.\n\nSample: Data of this current week contrasted and earlier week."
},
{"id":"14",
"q":"What is defined as catalog and types of catalogs in Cognos?",
"answer":"A catalog is defined as a file which contains information on Database tables and Impromptu users can create reports.\n\nFollowing are the types of catalog used:\n\n1. Personal\n\n2. Distributed\n\n3. Shared\n\n4. Secured"
},
{"id":"15",
"q":" What are question things? ",
"answer":" Question things are the most essential protest in structure administrator and it has a considerable measure of properties connected with it.\n\nThis is for the most part utilized for reporting and business knowledge. "
},
{"id":"16",
"q":"What is Metrics designer? ",
"answer":"Metrics Designer is a tool which is used modeling, deploying score cards and data loading procedures. "
},
{"id":"17",
"q":"What is the use of Cognos scenario?",
"answer":"Cognos scenario is used for finding the hidden trends and data patterns. "
},
{"id":"18",
"q":"What is a Pivot?",
"answer":"Pivot aids in the rotating the axis of the cube to offer a different presentation on the data"
},
{"id":"19",
"q":"What is the use of Cognos decision stream? ",
"answer":"Cognos decision stream is a tool that is used to extract and transform the data from data sources to target source of data"
},
{"id":"20",
"q":"What is Query studio?",
"answer":"Query studio is one of the studios in Cognos which is used in carrying out Adhoc queries"
},
{"id":"21",
"q":"What are the advantages of Cognos?",
"answer":"The advantages of Cognos include:\n\nPlanning\n\nAnalysis\n\nForecasting\n\nScorecard "
},
{"id":"22",
"q":"Is it possible to join multiple Databases in a Catalog? ",
"answer":"No, it is impossible to join multiple databases in a catalog and it is achievable by Hotfile. "
},
{"id":"23",
"q":"What is Bitmap Index?",
"answer":"A bitmap index is used replacing list of rowids for each key value.\n\nThis index is largely well-organized for data warehousing as it has low cardinality and low updates."
},{"id":"24",
"q":" Responsibility of Cognos Architect? ",
"answer":"An Architect is responsible for designing the interface by fulfilling the user requirements.\n\nOnce the interface has been designed it should be rigorously tested before distributing to the end user population."
},{"id":"25",
"q":"What are the types of index? ",
"answer":"Bitmap index ,B-tree index, Function based index ,reverse key and composite index. We used Bitmap index in our project for better performance."
},{"id":"26",
"q":"Define data stores in Cognos?",
"answer":"Data sources, also known as query databases, are relational databases, dimensional cubes, files, or other physical data stores that can be accessed through IBM Cognos8. Application Tier Components use data source connections to access data sources."
},{"id":"27",
"q":"What is Cardinality?",
"answer":"Relationships exist between two query subjects.\n\nThe cardinality of a relationship is the number of related rows for each of the two query subjects.\n\nThe rows are related by the expression of the relationship; this expression usually refers to the primary and foreign keys of the underlying tables."
},{"id":"28",
"q":"Define Surrogate Key? ",
"answer":"It has system-generated artificial primary key values, which allows to maintain historical records in the Data Warehouse more effectively."
},{"id":"29",
"q":" What are the User Interface Components?",
"answer":"* Cognos Connection * Report Studio * Query Studio * Frame work manager\n\n* Cognos configuration"
},{"id":"30",
"q":"What are Parameter Maps?",
"answer":"A Parameter Map is a key value pair used in creation of conditional Query Subjects.\n\nA Parameter map sub situates the values at the query at runtime."
},{"id":"31",
"q":" Define Cognos SQL? ",
"answer":"By default Cognos FM uses Cognos SQL to create and edit Query subjects.\n\n\nAdvantages:\n\nCan contain metadata from multiple data sources. 2. Have fewer database restrictions 3. Interact more effectively with Cognos applications.\n\n\nDisadvantages:\n\nYou can not enter nonstandard SQL."
},{"id":"32",
"q":"What is situated to be Cognos design?",
"answer":"Cognos Configuration is a BI authoritative apparatus which is utilized to characterize the conduct of Cognos 8 form. This will oversee design parameters. "
},{"id":"33",
"q":"What is the utilization of Cognos situation?",
"answer":"Cognos situation is utilized to locate the shrouded patterns and examples of information."
},{"id":"34",
"q":"What is situated to be Cognos design?",
"answer":"Cognos Configuration is a BI authoritative apparatus which is utilized to characterize the conduct of Cognos 8 form. This will oversee design parameters."
},
{"id":"35",
"q":"When can we use wizard control?",
"answer":"Whenever we want to accept multiple inputs from the user in STEP by STEP process we can use WIZARD CONTROL."
},
{"id":"36",
"q":" What is the utilization of Cognos choice stream?",
"answer":"Cognos choice stream is situated to be an apparatus which is utilized for extricating,changing the information from diverse information sources to target information source."
},{"id":"37",
"q":"What is called Cognos powerplay?",
"answer":"Cognos powerplay is only a multidimensional on-line investigation of information. "
},{"id":"38",
"q":"What are all the sorts of gateway utilized as a part of Cognos?",
"answer":"Taking after is the rundown of gateway utilized as a part of Cognos:\n\n1. Regular Gateway Interface (CGI)\n\n2. Network access Application Interface (ISAPI)\n\n3. Tomcat Server"
},{"id":"39",
"q":" What is a Datastore in Cognos? ",
"answer":"An information store is only a question database or a social database or records that can be gotten to through IBM Cognos."
},
{"id":"40",
"q":" Can we declare more than oneconnection string in web.config file? ",
"answer":"YES. But the connection string names must be different."
},{"id":"41",
"q":" When we will go for multiple web.config files? ",
"answer":"Whenever we want to define some separate settings for couple of web pages, we will create a new folder and we will add that couple of web pages to that folder and we will add a new Web.config file to that new folder and we will define that separate settings within that Web.config."
},{"id":"42",
"q":" What are all the types of gateway used in Cognos?",
"answer":"Common Gateway Interface (CGI)\n\nInternet Service Application Interface (ISAPI)\n\nTomcat Server"
},
{"id":"43",
"q":"What is the difference between Standard and Metrics folder?·",
"answer":"Standard Folder – This is a container of all folders and it is used for Organizational purposes. It acts like a local computer folder. It is yellow in color.\n\nMetrics Folder – This folder is used by Metrics studio to store metrics related information. Metrics folder will open up directly in Metrics studio and it is dark blue in color."
},
{"id":"44",
"q":"What is the use of Cognos scenario?",
"answer":" Cognos scenario is used to find the hidden trends and patterns of data."
},{"id":"45",
"q":" What are initial page components of Cognos connection?",
"answer":"Initial page components of Cognos connection are:\n\nThe Studio Toolbar\n\nThe Utilities Toolbar\n\nThe Tab Navigator"
},{"id":"46",
"q":"What is cube size?",
"answer":"2.0 GB It depends on ur project requirements. "
},{"id":"47",
"q":"What are the batches and it’s details?",
"answer":"Sequential(Run the sessions one by one Concurrent (Run the sessions simultaneously)"
},{"id":"48",
"q":" What is IQD?",
"answer":"IQD stands for Impromptu Query Definition. It is report save extension with .IQD it is use for creating a cube in power play transformer."
},{"id":"49",
"q":" What is DTM?",
"answer":"DTM transform data received from reader buffer and its moves transformation to transformation on row by row basis and it uses transformation caches when necessary. "
},{"id":"50",
"q":"What are cascading prompts? ",
"answer":"Cascading Prompts allows a user to use values selected from one prompt to filter values in another prompt."
}
]
}
"q":"What is a Data Warehouse?",
"answer":"A Data Warehouse is a collection of data marts representing historical data from different operation data sources (OLTP). The data from these OLTP are structured and optimized for querying and analysis in a Data Warehouse. "
},
{"id":"2",
"q":"What is Cognos Reporting tool? ",
"answer":"Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse. "
},
{"id":"3",
"q":"What is Cognos Connection?",
"answer":"It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data."
},
{"id":"4",
"q":"What is Report item?",
"answer":"Report item is nothing but a query item when it is drag and drop into the work area. "
},
{"id":"5",
"q":"What is query subject?",
"answer":"A query subject is the basic building block in Framework Manager. A query subject is a set of query items that have an inherent relationship."
},
{"id":"6",
"q":"What is set to be Cardinality?",
"answer":"Cardinality is defined as relationships between the tables. Following are relationship formed between the tables.\n\nOne to One\n\nOne to Many\n\nMany to Many\n\nMany to One "
},
{"id":"7",
"q":" What is defined as Data mining?",
"answer":" Data mining is the process of getting hidden trends from a data ware house. "
},
{"id":"8",
"q":"What are all the different types of prompt in Cognos?",
"answer":"Value prompt\n\nText Prompt\n\nDate prompt\n\nTime prompt\n\nDate and time prompt"
},
{"id":"9",
"q":"What is situated to be Cardinality? ",
"answer":"Cardinality is characterized as connections between the tables. Taking after are relationship shaped between the tables.\n\n1. Balanced\n\n2. One to Many\n\n3. Many to Many\n\n4. Many to One"
},
{"id":"10",
"q":"What are the components of Report Net?",
"answer":"Taking after are the components of Report Net:\n\n1. Framework manager\n\n2. Cognos connection\n\n3. Query Studio\n\n4. Report Studio"
},
{"id":"11",
"q":"What do you mean by Drill Through report?",
"answer":"Drill through reporting is utilized to connection starting with one report then onto the next report.\n\nIt has guardian and tyke relationship between the reports."
},
{"id":"12",
"q":" Notice the distinction in the middle of “macros” and ‘brief’?",
"answer":"Large scale is utilized to run situated of directions to execute the report however incite give an approach to change the report alterably."
},
{"id":"13",
"q":"What is a Snapshot?",
"answer":"A preview is made to duplicate the definite information that is identified with current report and contrast and another report.\n\nSample: Data of this current week contrasted and earlier week."
},
{"id":"14",
"q":"What is defined as catalog and types of catalogs in Cognos?",
"answer":"A catalog is defined as a file which contains information on Database tables and Impromptu users can create reports.\n\nFollowing are the types of catalog used:\n\n1. Personal\n\n2. Distributed\n\n3. Shared\n\n4. Secured"
},
{"id":"15",
"q":" What are question things? ",
"answer":" Question things are the most essential protest in structure administrator and it has a considerable measure of properties connected with it.\n\nThis is for the most part utilized for reporting and business knowledge. "
},
{"id":"16",
"q":"What is Metrics designer? ",
"answer":"Metrics Designer is a tool which is used modeling, deploying score cards and data loading procedures. "
},
{"id":"17",
"q":"What is the use of Cognos scenario?",
"answer":"Cognos scenario is used for finding the hidden trends and data patterns. "
},
{"id":"18",
"q":"What is a Pivot?",
"answer":"Pivot aids in the rotating the axis of the cube to offer a different presentation on the data"
},
{"id":"19",
"q":"What is the use of Cognos decision stream? ",
"answer":"Cognos decision stream is a tool that is used to extract and transform the data from data sources to target source of data"
},
{"id":"20",
"q":"What is Query studio?",
"answer":"Query studio is one of the studios in Cognos which is used in carrying out Adhoc queries"
},
{"id":"21",
"q":"What are the advantages of Cognos?",
"answer":"The advantages of Cognos include:\n\nPlanning\n\nAnalysis\n\nForecasting\n\nScorecard "
},
{"id":"22",
"q":"Is it possible to join multiple Databases in a Catalog? ",
"answer":"No, it is impossible to join multiple databases in a catalog and it is achievable by Hotfile. "
},
{"id":"23",
"q":"What is Bitmap Index?",
"answer":"A bitmap index is used replacing list of rowids for each key value.\n\nThis index is largely well-organized for data warehousing as it has low cardinality and low updates."
},{"id":"24",
"q":" Responsibility of Cognos Architect? ",
"answer":"An Architect is responsible for designing the interface by fulfilling the user requirements.\n\nOnce the interface has been designed it should be rigorously tested before distributing to the end user population."
},{"id":"25",
"q":"What are the types of index? ",
"answer":"Bitmap index ,B-tree index, Function based index ,reverse key and composite index. We used Bitmap index in our project for better performance."
},{"id":"26",
"q":"Define data stores in Cognos?",
"answer":"Data sources, also known as query databases, are relational databases, dimensional cubes, files, or other physical data stores that can be accessed through IBM Cognos8. Application Tier Components use data source connections to access data sources."
},{"id":"27",
"q":"What is Cardinality?",
"answer":"Relationships exist between two query subjects.\n\nThe cardinality of a relationship is the number of related rows for each of the two query subjects.\n\nThe rows are related by the expression of the relationship; this expression usually refers to the primary and foreign keys of the underlying tables."
},{"id":"28",
"q":"Define Surrogate Key? ",
"answer":"It has system-generated artificial primary key values, which allows to maintain historical records in the Data Warehouse more effectively."
},{"id":"29",
"q":" What are the User Interface Components?",
"answer":"* Cognos Connection * Report Studio * Query Studio * Frame work manager\n\n* Cognos configuration"
},{"id":"30",
"q":"What are Parameter Maps?",
"answer":"A Parameter Map is a key value pair used in creation of conditional Query Subjects.\n\nA Parameter map sub situates the values at the query at runtime."
},{"id":"31",
"q":" Define Cognos SQL? ",
"answer":"By default Cognos FM uses Cognos SQL to create and edit Query subjects.\n\n\nAdvantages:\n\nCan contain metadata from multiple data sources. 2. Have fewer database restrictions 3. Interact more effectively with Cognos applications.\n\n\nDisadvantages:\n\nYou can not enter nonstandard SQL."
},{"id":"32",
"q":"What is situated to be Cognos design?",
"answer":"Cognos Configuration is a BI authoritative apparatus which is utilized to characterize the conduct of Cognos 8 form. This will oversee design parameters. "
},{"id":"33",
"q":"What is the utilization of Cognos situation?",
"answer":"Cognos situation is utilized to locate the shrouded patterns and examples of information."
},{"id":"34",
"q":"What is situated to be Cognos design?",
"answer":"Cognos Configuration is a BI authoritative apparatus which is utilized to characterize the conduct of Cognos 8 form. This will oversee design parameters."
},
{"id":"35",
"q":"When can we use wizard control?",
"answer":"Whenever we want to accept multiple inputs from the user in STEP by STEP process we can use WIZARD CONTROL."
},
{"id":"36",
"q":" What is the utilization of Cognos choice stream?",
"answer":"Cognos choice stream is situated to be an apparatus which is utilized for extricating,changing the information from diverse information sources to target information source."
},{"id":"37",
"q":"What is called Cognos powerplay?",
"answer":"Cognos powerplay is only a multidimensional on-line investigation of information. "
},{"id":"38",
"q":"What are all the sorts of gateway utilized as a part of Cognos?",
"answer":"Taking after is the rundown of gateway utilized as a part of Cognos:\n\n1. Regular Gateway Interface (CGI)\n\n2. Network access Application Interface (ISAPI)\n\n3. Tomcat Server"
},{"id":"39",
"q":" What is a Datastore in Cognos? ",
"answer":"An information store is only a question database or a social database or records that can be gotten to through IBM Cognos."
},
{"id":"40",
"q":" Can we declare more than oneconnection string in web.config file? ",
"answer":"YES. But the connection string names must be different."
},{"id":"41",
"q":" When we will go for multiple web.config files? ",
"answer":"Whenever we want to define some separate settings for couple of web pages, we will create a new folder and we will add that couple of web pages to that folder and we will add a new Web.config file to that new folder and we will define that separate settings within that Web.config."
},{"id":"42",
"q":" What are all the types of gateway used in Cognos?",
"answer":"Common Gateway Interface (CGI)\n\nInternet Service Application Interface (ISAPI)\n\nTomcat Server"
},
{"id":"43",
"q":"What is the difference between Standard and Metrics folder?·",
"answer":"Standard Folder – This is a container of all folders and it is used for Organizational purposes. It acts like a local computer folder. It is yellow in color.\n\nMetrics Folder – This folder is used by Metrics studio to store metrics related information. Metrics folder will open up directly in Metrics studio and it is dark blue in color."
},
{"id":"44",
"q":"What is the use of Cognos scenario?",
"answer":" Cognos scenario is used to find the hidden trends and patterns of data."
},{"id":"45",
"q":" What are initial page components of Cognos connection?",
"answer":"Initial page components of Cognos connection are:\n\nThe Studio Toolbar\n\nThe Utilities Toolbar\n\nThe Tab Navigator"
},{"id":"46",
"q":"What is cube size?",
"answer":"2.0 GB It depends on ur project requirements. "
},{"id":"47",
"q":"What are the batches and it’s details?",
"answer":"Sequential(Run the sessions one by one Concurrent (Run the sessions simultaneously)"
},{"id":"48",
"q":" What is IQD?",
"answer":"IQD stands for Impromptu Query Definition. It is report save extension with .IQD it is use for creating a cube in power play transformer."
},{"id":"49",
"q":" What is DTM?",
"answer":"DTM transform data received from reader buffer and its moves transformation to transformation on row by row basis and it uses transformation caches when necessary. "
},{"id":"50",
"q":"What are cascading prompts? ",
"answer":"Cascading Prompts allows a user to use values selected from one prompt to filter values in another prompt."
}
]
}