Interview Questions.

Question 1. Why We Cannot Create An Aggregate On An Ods Object?

Answer :

Operational Data Store has very low data latency. Data moved to ODS totally on occasion primarily based in place of time primarily based ETL to Data Warehouse/Data Mart.

ODS is more toward OLTP device. We don’t usually prefer to store aggregated records in OLTP. So it's miles with ODS.

Unlike facts warehouse in which data is HISTORICAL, ODS is near real time(NRT). So statistics aggregation is less crucial is ODS as facts continues changing.

Question 2. How Do You Conditional Format.?

Answer :

while creating a chat in BI Answers, you could outline the conditions and can observe color formatting.

Siebel - CRM Interview Questions
Question 3. What Is Business Intelligence?

Answer :

Business Intelligence is a system for growing the aggressive gain of a business via shrewd use of available statistics in choice making.

The five key tiers of Business Intelligence:

Data Sourcing
Data Analysis
Situation Awareness
Risk Assessment
Decision Support
Question four. What Is Hierarchy Relationship In A Dimension?

Answer :

Whether it is:

1:1
1:m
m:m
1:M
Siebel - CRM Tutorial
Question five. What Is Guided Navigation?

Answer :

It is just the arrangement of hyperlinks to guide the consumer to navigate among the reports to do the evaluation.

Informatica Interview Questions
Question 6. What Is A Universe In Business Intelligence?

Answer :

A “universe” is a “Business object” terminology. Business items also happens to be the call of the organisation. The universe is the interfacing layer among the customer and the datawarehouse . The universe defines the relationship a few of the diverse tables within the datawarehouse.

Universe is a semantic layer among the database and the person interface (reviews).

Question 7. How To Connect Gde To Co Operating System In Abinitio?

Answer :

We can join AbInitio GDE with Co>working machine using Run->Settings.In there u can specify the host IP address and the relationship type .

Informatica Tutorial IBM Cognos Interview Questions
Question 8. How The Users Created Differs From Rpd/answers/dashboards Level?

Answer :

RPD customers can do administrator responsibilities like adding new records supply, create hierarchies, alternate column names in which as Answers users may create new charts, edit the ones charts and Dashboard users can also best view and examine the dashboard or can edit dashboard by including/removing charts gadgets.

Question 9. What Is Olap In Business Intelligence?

Answer :

Online Analytical Processing, a category of software program tools that provides evaluation of facts stored in a database. OLAP tools allow customers to research extraordinary dimensions of multidimensional information. For example, it offers time series and trend evaluation perspectives. The leader issue of OLAP is the OLAP server, which sits between a customer and a database control systems (DBMS). The OLAP server is familiar with how facts is prepared in the database and has special functions studying the data.

A desirable OLAP interface has writes an green sq. And reads an correct information from db. To design and architect having true understanding on DB expertise the report necessities.

OBIEE Interview Questions
Question 10. Explain The Name Of Some Standard Business Intelligence Tools In The Market?

Answer :

Some of the same old Business Intelligence equipment inside the market According to there overall performance

MICROSTRATEGY.
BUSINESS OBJECTS,CRYSTAL REPORTS.
COGNOS REPORT NET.
MS-OLAP SERVICES.
IBM Cognos Tutorial
Question 11. Online/offline Mode How It Impact In Dev And Deployment?

Answer :

Online Mode- You could make adjustments in the RPD document and push in adjustments so as to be immediately visible to the customers who're already linked. This characteristic we may also use in production environment.

Offline mode- can be beneficial in test or improvement environment.

Hadoop Interview Questions
Question 12. What Are The Various Modules In Business Objects Product?

Answer :

Business Objects Reporter
Reporting & Analyzing device
Designer
Universe introduction
database interaction
connectivity
Supervisor: For Administrative purposes.

Webintelligence: Access of record records through internet.

BroadCast Agent: For scheduling the reviews.

Data Integrator: The ETL tool of Business Objects, designed to address large amounts of statistics.

Siebel - CRM Interview Questions
Question thirteen. What Are The Various Modules In Business Objects Product Suite?

Answer :

Supervisor: Supervisor is the manipulate middle for the management and security of your complete BusinessObjects deployment.

Designer: Designer is the tool used to create, control and distribute universe for BusinessObjects and WebIntelligence Users. A universe is a file that includes connection parameters for one or more database middleware and SQL shape known as objects that map to actual SQL shape inside the database as columns,tables and database.

BusinessObjects Full consumer Reporting tool: Helps to create commercial enterprise gadgets reports based on the universe and additionally from the alternative statistics assets.

BusinessObjects Thin client Reporting device: Helps to query and evaluation on the universe and additionally proportion the file among other customers. It doesn’t require any software, just need a web browser and the device connected to the business objetcs server.

Auditor: Tool is used for screen and evaluation person and gadget interest.

Application Foundation: This module covers a set of products that's used for Enterprise Performance Management (EPM). The gear are 

Dashboard manager.
Scorecard.
Performance Management Applications.
OBIEE Tutorial
Question 14. Explain The Concepts And Capabilities Of Business Intelligence.?

Answer :

Business Intelligence enables to manipulate records with the aid of making use of one of a kind competencies, technologies, protection and first-class risks. This additionally allows in achieving a better knowledge of facts.Business intelligence may be taken into consideration because the collective records. It helps in making predictions of enterprise operations using accrued information in a warehouse. Business intelligence software helps to tackle income, economic, production and so on commercial enterprise records. It facilitates in a higher decision making and may be additionally taken into consideration as a selection guide gadget.

Question 15. What Is Olap, Molap, Rolap, Dolap, Holap? Explain With Examples?

Answer :

OLAP – On-Line Analytical Processing :  Designates a class of packages and technologies that allow the gathering, garage, manipulation and reproduction of multidimensional records, with the intention of evaluation.

MOLAP – Multidimensional OLAP : This term designates a cartesian facts structure extra in particular. In impact, MOLAP contrasts with ROLAP. Inb the previous, joins among tables are already suitable, which complements performances. In the latter, joins are computed at some point of the request. Targeted at businesses of customers as it’s a shared environment. Data is stored in an exclusive server-based totally format. It plays more complex analysis of data.

DOLAP – Desktop OLAP : Small OLAP products for neighborhood multidimensional analysis Desktop OLAP. There may be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects).

Designed for low-cease, unmarried, departmental user. Data is saved in cubes at the computer. It’s like having your very own spreadsheet. Since the facts is nearby, cease users dont ought to fear about performance hits in opposition to the server.

ROLAP – Relational OLAP : Designates one or several celebrity schemas saved in relational databases. This generation allows multidimensional evaluation with facts saved in relational databases. Used for massive departments or groups as it supports huge amounts of information and users.

HOLAP: Hybridization of OLAP.

Siebel System Admin Interview Questions
Question sixteen. From Where You Get The Logical Query Of Your Request?

Answer :

The logical SQL generated by using the server may be viewed in BI Answers. If I actually have not understood the question, Please boost your voice.

Hadoop Tutorial
Question 17. Name Some Of The Standard Business Intelligence Tools In The Market.

Answer :

Business intelligence equipment are to document, examine and gift records. Few of the equipment available in the market are:

Eclipse BIRT Project:- Based on eclipse. Mainly used for net programs and it is open source.
Freereporting.Com:- It is a unfastened net primarily based reporting tool.
JasperSoft:- BI tool used for reporting, ETL etc.
Pentaho:- Has information mining, dashboard and workflow abilties.
Openl:- A internet software used for OLAP reporting.
Siebel EAI Interview Questions
Question 18. Why An Infocube Has Maximum Of sixteen Dimensions?

Answer :

It depends upon the Database limits supplied to define the Foreign key constraint, e.G. In Sql Server 2005, the encouraged max limit for overseas keys is 253, however you may define extra.

Informatica Interview Questions
Question 19. Major Challenges You Faced While Creating The Rpd?

Answer :

Every now and then there are problems with the database connections however the hassle while developing the repository RPD files comes with complex schemas made on OLTP structures which include lot of joins and checking the consequences. Th sort of be part of made need to be checked. By default it's miles inner join but sometimes the requirement demands different types of joins. There are lot of issues with the date codecs additionally.

Hadoop MapReduce Tutorial
Question 20. Explain The Dashboard In The Business Intelligence.?

Answer :

A dashboard in business intelligence allows huge statistics and reports to be read in a single graphical interface. They assist in making faster decisions via replying on measurable records seen at a look. They can also be used to get into info of this records to research the foundation cause of any enterprise overall performance. It represents the enterprise information and enterprise country at a excessive degree. Dashboards can also be used for cost control. Example of want of a dashboard: Banks run heaps of ATM’s. They want to recognise how a lot cash is deposited, how plenty is left and many others.

Oracle Data Integrator (ODI) Interview Questions
Question 21. What Is Bas? What Is The Function?

Answer :

The Business Application Support (BAS) purposeful region at SLAC gives administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software program improvement and maintenance of the PeopleSoft? Applications and session to clients with their computer-related tasks.

Question 22. What Are Global Filter And How They Differ From Column Filter?

Answer :

Column clear out- honestly a clear out carried out on a column which we are able to use to restrict our column values while pulling the facts or in charts to look the associated content material.

Global clear out- Not certain. I apprehend this clear out can have effect on across the utility but I certainly don’t recognize where and the way it can be user. I heard of global variables however not worldwide filters.

Question 23. Explain The Sql Server 2005 Business Intelligence Components.?

Answer :

SQL Server Integration Services:- Used for records transformation and introduction. Used in records acquisition shape a source machine.
SQL Server Analysis Services: Allows statistics discovery the usage of information mining. Using enterprise common sense it supports facts enhancement.
SQL Server Reporting Services:- Used for Data presentation and distribution access.
IBM Cognos TM1 Interview Questions
Question 24. Name Some Of The Standard Business Intelligence Tools In The Market?

Answer :

Some of the usual Business Intelligence tools within the market According to their overall performance

MICROSTRATEGY
BUSINESS OBJECTS,CRYSTAL REPORTS
COGNOS REPORT NET
MS-OLAP SERVICES
Or

Seagate Crystal document
SAS
Business items
Microstrategy
Cognos
Microsoft OLAP
Hyperion
Microsoft incorporated offerings
IBM Cognos Interview Questions
Question 25. How Do We Enhance The Functionality Of The Reports In Bo?

Answer :

You can format the BO Reports by using using diverse functions available. You can turn the table reviews right into a 2-Dimensional or 3-Dimensional charts. You can observe an Alert to reveal a few records in a special layout , primarily based on some business rule. You also can create a few activates, if you want to asks person to offer some enter values before seeing the reviews, this manner they may see handiest filtered statistics. There are many similar thrilling alternatives to be had to enhance the reports.

Question 26. Where To Configure The Scheduler?

Answer :

We configure the OBIEE scheduler in database.

Hadoop MapReduce Interview Questions
Question 27. What Are Dashboards?

Answer :

A management reporting tool to gauge how properly the organisation agency is acting. It typically makes use of “site visitors-lighting” or “smiley faces” to decide the status.

OBIEE Interview Questions
Question 28. How To Hide Certain Columns From A User?

Answer :

Application access degree safety- Do no longer add the column inside the file, Do not upload the column inside the presentation layer.

Question 29. Explain About Auditing In Bo Xi R2? What Is The Use Of It?

Answer :

Auditor is used by the business items directors to understand the complete records of the business intelligence system.

It monitors complete BI device at a glance.
Analyzes usage and trade impact
optimises the BI deployment
Hadoop Administration Interview Questions
Question 30. How Can We Enable Drills In A Given Column Data?

Answer :

To permit Drill down for a column, it have to be included inside the hierarchy in OBIEE. Hyperion IR has a drill anywhere characteristic wherein don’t ought to define and can drill to any to be had column.

Question 31. How Do We Tune The Bo Reports For Performance Improvement?

Answer :

We can music the file by way of the use of index awareness in universe

Question 32. Is Drill Down Possible Without The Attribute Being A Part Of A Hierarchical Dimension?

Answer :

No, it’s no longer feasible.

Cognos ReportNet (CRN) Interview Questions
Question 33. What Is The Definition Of Obia?

Answer :

Definition: Oracle Business Intelligence Applications is a prebuilt commercial enterprise intelligence solution that deliver intelligence throughout an corporation, empowering customers at all levels from the front line operational users to senior control with the key statistics they need to maximise effectiveness.

Hadoop Interview Questions
Question 34. What Are The Modules Included In Obia?

Answer :

Oracle BI Applications includes the following modules:

Oracle Financial Analytics (Manage economic overall performance throughout locations, customers, products, and territories, and receive actual-time indicators on events which could effect monetary situation)

Oracle Human Resources Analytics (Correlate monetary measures with key personnel metrics to illustrate HR’s strategic cost within the organization)

Oracle Procurement and Spend Analytics (Creates visibility to spending patterns for each direct and oblique spend, permitting customers to become aware of and recognise the savings opportunities, with the capability to do the spend analysis by means of commodities, suppliers, dealer places, buying places, business units, value facilities, shoppers and contract utilization)

Oracle Project Analytics

Oracle Supply Chain and Order Management Analytics, Etc.,

Question 35. Obia Is Composed Of?

Answer :

Oracle Business Intelligence Application (OBIA) consists of : 

INFORMATICA + DAC  + OBIEE

Question 36. Explain The Components Of Obia?

Answer :

components of OBIA : 

DAC Repository metadata documents: Content includes repository gadgets along with tables, challenge areas, execution plans, and obligations, and is contained in XML files.The DAC customer and server were blanketed till version 7.Nine.5. Since then it's miles a separate installer.

Embedded Informatica ETL device and repository : ETL is a 3rd birthday celebration tool which incorporates mappings (wrapped in workflows) to extract statistics from the supported source structures (diverse variations of standard applications consisting of Siebel CRM - yes it became first - , Oracle eBusiness Suite, Peoplesoft, JDEdwards and SAP (BI Apps version 7.8.Four) ) and cargo the records into the Oracle Business Analysis Warehouse.

Pre constructed metadata content material : This metadata content is contained within the Oracle BI Applications repository document  (OracleBIAnalyticsApps.Rpd). It maps the supply bodily tables to a accepted commercial enterprise model and consists of extra than 100 presentation catalogs (aka problem regions) to permit queries and segmentation the use of Oracle BI customers inclusive of Answers, Dashboards and Segment Designer

Pre built reports and dashboard content : Contains loads of requests and prepared-to-use dashboards which permit tight integration among the supply programs and the BI infrastructure  

Oracle Business Analytics Warehouse : The prebuilt records warehouse that holds facts extracted, converted, and loaded from the  transactional database

Ad-hoc Analysis : Metadata layer serves as foundation to provide flexible and intuitive advert-hoc reporting and custom dashboard designs via Oracle BI Answers and Oracle BI Dashboard equipment which are part of the OBIEE toolset.

Role-Based Dashboards : Delivered role-based dashboards are effortlessly configurable to meet unique organizational desires and practices.

Siebel System Admin Interview Questions
Question 37. What Are The Tables Used By Obia?

Answer :

Aggregate tables (_A) : These tables comprise summed (aggregated) information.
Dimension tables (_D) : Dimension tables with descriptive data
Staging tables for Dimension(_DS) :These tables comprise the information which is to be loaded to Target
Fact tables (_F) : Tables storing information and measures
Dimension Hierarchy tables (_DH) : Tables that shop the dimension's hierarchical structure
Fact Staging tables (_FS) : Staging tables used to preserve the metrics being analyzed with the aid of dimensions which have now not been thru the ?nal ETL transformations.