Question 1

what is flat aggregation?

Accepted Answer

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates

Question 2

What is Catalog Manager? How to move reports and dashboards using Catalog Manager?

Accepted Answer

Catalog Manager supports command line options To move reports and dashboards, we need to use some general syntax using catalog manager eg: catalogmanager -online/offline -cmd {report | replace | export} {command line options} In extra, by keeping it online, This will automatically open up the catalog manager without having the need to enter the connection details every time

Question 3

How would you handle conditional formats in BI?

Accepted 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

Question 4

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

Accepted 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

Question 5

Why an infocube has maximum of 16 dimensions?

Accepted 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, eg in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more

Question 6

What is BAS? What is its function ?

Accepted 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

Question 7

Which of the following is a function of inventory?

Accepted Answer

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.

Question 8

Which best describes the practice of outsourcing?

Accepted 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 (eg payroll processing, claims processing) and operational, and/or non-core functions (eg 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

Question 9

Which of the following statements about financial aid are true?

Accepted Answer

Financial aid is available to community college students.

Question 10

In the expansion phase of a business cycle

Accepted Answer

There are basically two important phases in a business cycle that are prosperity and depression. The other phases that are expansion, peak, trough and recovery are intermediary phases. Expansion is a phase in which, when the economy moves from a trough to a peak. It is a period when the level of business activity surges and gross domestic product (GDP) expands until it reaches a peak.

Question 11

How do you eliminate duplicate values in DB2 SELECT?

Accepted Answer

Use SELECT DISTINCT in DB2 query The DISTINCT keyword can be used to return only distinct (different) values Syntax: SELECT DISTINCT column1,column2 FROM table_name;

Question 12

What is UNION , UNION ALL?

Accepted Answer

Both these are used to combine the results of different SELECT statements UNION - Selects only distinct values UNION ALL - Selects duplicate values also Syntax: SELECT column_name(s) FROM table1 UNION / UNION ALL SELECT column_name(s) FROM table2; Notice that each SELECT statement within the UNION must have the same number of columns The columns must also have similar data types Also, the columns in each SELECT statement must be in the same order

Question 13

What is a cursor ? Why should it be used in DB2?

Accepted Answer

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time Cursor should be used because the host language can deal with only one row at a time

Question 14

What is DCLGEN?

Accepted Answer

DeCLarations GENerator : used to create the host language copy books for the table definitions Also creates the DECLARE table

Question 15

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

Accepted Answer

a nonmatching index scan if ACCESSTYPE = 1

Question 16

How does DB2 determine what lock- size to use?

Accepted Answer

1 Based on the lock-size given while creating the table space 2 Programer can direct the DB2 what lock-size to use 3 If lock - size ANY is specified, DB2 usually chooses a lock-size of PAGE

Question 17

What is RUNSTATS?

Accepted Answer

A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path It also collects statistics used for space management These statistics are stored in DB2 catalog tables

Question 18

How do you insert a record with a nullable column?

Accepted Answer

To insert a NULL, move -1 to the null indicator To insert a valid value, move 0 to the null indicator

Question 19

What is REORG? When it is used?

Accepted Answer

REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented

Question 20

What is sqlcode -811?

Accepted Answer

SELECT statement has resulted in retrieval of more than one row

Technology Questions