2
Q:

What is hierarchy relationship in a dimension. whether it is: 1) 1:1 2) 1:m 3) m:m 

Answer:



Q:

Which best describes the practice of outsourcing?

Answer

 


In business, outsourcing is an agreement in which one company contracts its own internal activity to different company. It involves the contracting out of a business process (e.g. payroll processing, claims processing) and operational, and/or non-core functions (e.g. manufacturing, facility management, call center support) to another party (see also business process outsourcing).


 


A company moves some of its jobs to another country and employing workers in other countries to save on labor costs best describes the practice of outsourcing.

Report Error

View answer Workspace Report Error Discuss

0 49
Q:

Which of the following is a function of inventory?

A) to take advantage of quantity discounts B) to decouple various parts of the production process
C) to provide a selection of goods for anticipated customer demand and to separate the firm from fluctuations in that demand D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:

All the above given statements are functions of Inventory.

 

Inventory or stock is the goods and materials that a business holds for the ultimate goal of resale. Inventory management is a discipline primarily about specifying the shape and placement of stocked goods.


The primary function of inventory is to use marketing and production to increase profitability, to get the maximum amount for the business' investment. There are other functions of inventory, such as balancing supply and demand, improving efficiency, establishing a safety stock and geographical specialization.

Report Error

View Answer Workspace Report Error Discuss

Filed Under: Business Intelligence - Technology
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 54
Q:

Why we can't create an aggregate on an ODS Object?

Answer

1. 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. 


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


3. 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.

Report Error

View answer Workspace Report Error Discuss

2 696
Q:

How do we Tune the BO Reports for Performance Improvement?

Answer

We can tune the report by using index awarness in universe

Report Error

View answer Workspace Report Error Discuss

2 935
Q:

What is BAS? What is its function ?

Answer

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft applications and consultation to customers with their computer-related tasks.


It's called Broadcast Agent Server. Its function is torun the jobs or reports scheduled and can be monitored using Broadcast Agent Console.

Report Error

View answer Workspace Report Error Discuss

0 707
Q:

Why an infocube has maximum of 16 dimensions?

Answer

Because any Database will supports only 16 foreign keys in a database table. 


It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

Report Error

View answer Workspace Report Error Discuss

0 699
Q:

How do we enhance the functionality of the reports in BO?

Answer

You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format , based on some business rule. You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data. There are many similar exciting options available to enhance the reports.

Report Error

View answer Workspace Report Error Discuss

0 626
Q:

How would you handle conditional formats in BI?

Answer

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers.

Report Error

View answer Workspace Report Error Discuss

0 554