Business intelligence Interview Questions and Answers

1 :: What are the various modules in Business Objects product Suite?

Supervisor:
Supervisor is the control center for the administration and security of your entire BusinessObjects deployment.

Designer:
Designer is the tool used to create, manage and distribute universe for BusinessObjects and WebIntelligence Users. A universe is a file that containe connection parameters for one or more database middleware and SQL structure called objects that map to actual SQL structure in the database as columns,tables and database.

BusinessObjects Full client Reporting tool:
Helps to create businessobjects reports based on the universe and also from the other data sources.

BusinessObjects Thin client Reporting tool:
Helps to querry and analysis on the universe and also share the report among other users. It doesnt require any software, just need a webbrowser and the system connected to the businessobjetcs server.

Auditor:
Tool is used for monitor and analysis user and system activity.

Application Foundation:
This module covers a set of products which is used for Enterprise Performance Management (EPM). The tools are

► Dashboard manager
► Scorecard
► Performance Management Applications

4/5 Rating (1 vote)

Is This Answer Correct?    1 Yes 0 No

2 :: Explain the Name of some standard Business Intelligence tools in the market?

Some of the standard Business Intelligence tools in the market According to there performance

1)MICROSTRATEGY
2)BUSINESS OBJECTS,CRYSTAL REPORTS
3)COGNOS REPORT NET
4)MS-OLAP SERVICES

0/5 Rating (0 vote)

Is This Answer Correct?    2 Yes 0 No

3 :: How to connect GDE to Co Operating system in Abinitio?

We can connect Ab Initio GDE with Co>operating system using Run->Settings.In there u can specify the host IP address and the connection type .Refer Ab Initio help for further details.

0/5 Rating (0 vote)

Is This Answer Correct?    1 Yes 0 No

4 :: what is hierarchy relationship in a dimension.
whether it is:
1. 1:1
2. 1:m
3. m:m

1:M

0/5 Rating (0 vote)

Is This Answer Correct?    1 Yes 0 No

5 :: Why we ca not create an aggregate on an ODS Object?

► Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.

► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.

► Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.

4/5 Rating (1 vote)

Is This Answer Correct?    1 Yes 0 No