interview questions

[eliasmv]

Hi all
Can any one tell me from where can i get the tutorial to learn the tools of datawarehousing
Waiting for reply
Regards
ellias

[rameshjaydev]

Originally Posted by efulgent

hi,
can any one please send interview questions on microstrategy and
businessobjects.

thanks
naveen

hi naveen
sending some interview question for u
MICROSTRATEGY Interview Questions

1) What is ROLAP and MOLAP? Is MicroStrategy a ROLAP or MOLAP tool?

ROLAP (Relational online Analytical Processing) tools do not use pre-calculated data cubes. Instead, they intercept the query and pose the question to the standard relational database and its tables in order to bring back the data required to answer the question

MOLAP (Multidimensional online Analytical Processing) tools utilize a pre-calculated data set, commonly referred to as a data cube, that contains all the possible answers to a given range of questions.

MicroStartegy is ROLAP tool.

2)What is star schema and snowflake schema?

Star Schema is a highly denormalized schema whereas snowflake schema is hight normalized schema.Star schema is characterized by large number of rows in a table and less number of joins between tables.Snowflake schema is characterized by less number of rows in a table while more number of joins between tables.

3)What are the advantages and disadvantages of star and snowflake schema?

Star Schema Advantages: Reduces the number of joins between the tables and hence faster performance

Star Schema Disadvantages:Requires Most amount of storage space.

Snowflake Schema Advantages: Minimum storage space and minimum data redudancy

Snowflake Schema Disadvantages:Requires more joins to get information from look up tables hence slow performance.

4)What is the difference between 2 tier,3 tier and 4 tier architecture in MicroStrategy?

In 2 tier architecture, the MicroStrategy Desktop itself queries aganist the Data warehoue and the Metadata with out the Intermediate tier of the Intelligence server.

The 3 Tier architecture comprises a Intelligence server between MicroStrategy Desktop and the data Warehouse and the Metadata.

The 4 tier architecture is same as 3 tier except it has a additional component of MicroStratey Web.

5)What are adhoc reports and static reports?

Adhoc reports run in real time based on the input parameters provided by the user at the run time.In Microstrategy, adhoc reports are created using Prompts.

In static reports, users won't be provide any input parameters.These reports are usaully schedule to run overnight and ready to view immediatley in the mornings using cache.

6)What is a filter?

Filter is a public object.It is used to restrict the data retrived by the report from the database tables.From SQL perspective it corresponds to the "WHERE" Clause.

7)What are VLDB properties?

Using VLDB properties we can change the way how the SQL is generated.Some of them are below:

Perform full outer joins
Check for Zeros and Nulls in the denominator while performing divisions in Metrics.
Creating Sub queries
Creating temperory tables.

8)What are Consolidations?

Consloidations enable to group together attibute elements and create a virtual attribute.They perform Row level maths.

9)What are custom groups?

Custom groups are used to create different filters to different rows of a report.For example, a report can created to display top 5 customers as well as bottom 5 customers in the one report using custom group.

10)What are Passthrough Functions?

Pass through functions are used to utilize various special functions that specific to databases.Some of the passthrough functions available are Applysimple and Applycomparision.

11)What is a Security filter?

Security filter is used to apply security at the database data level.Whenever a users associated with security filter runs a report, a WHERE clause is always included in the report sql with the condition defined in the Security Filter.

[sriharid]

hai
can we view data records when we retriving data records from the oracle database in ab initio.
when i am trying this i am getting this messages
('m_db_dump' is not recognized as an internal or external command,
operable program or batch file.
'sleep' is not recognized as an internal or external command,
operable program or batch file.)

[sriharid]

hi
can any one tell me select function in fuse component
hari

[kalareddy]

In most of the interviews, they ask more questions on different OLAP models and how they related to the industry.. make sure you prepare and understand how thse models are using in specific to the company you will be attending interview... like if you are going for bank related company, make sure you learn how this can be using in banking systems... This is really important and decides you fate in Interview...

[kalareddy]

Hello,

There are not many sites offer you free training tutorials on the tools... The best thing would be go to their site , download evaluation copy and try it your self. Most of the DataWarehousing tools comes with step by step documentation along with screen shots which really helps you to learn the tool.

if you are good in functions, SQL and little scripting , you should be able to get good hold on it with 3 weeks of effort.

Good Luck.

Thanks,
Chandra

[kalareddy]

Hello there,

if you have programming and database skills... I don't think you need any training... Since it's just a tool where you can code using built in functions and SQl statements.

If you get an evaluation copy from their website... you should be able to learn on your own...

Add this to the list of things you need to learn...

Industry usage.. This is really important to know how it's being using in varioud industries...

Good Luck...

Thanks,
Chandra

[dave1234]

You can download an IBM Book on Dimensional Modeling from the following

link:

http://www.redbooks.ibm.com/abstract...7138.html?Open

This is an excellent IBM Redbook on Data warehouse design and

Dimensional Modeling design.

Great to read,
Dave

[dwuser]

Hello Friends,
You can download an IBM Book on Star Schema from the following link:

http://www.redbooks.ibm.com/abstract...7138.html?Open

This is an excellent IBM Redbook on Data warehouse design and Dimensional Modeling design.

Great to read,
Dave

[dwuser]

Hello Friends,
In order to understand the process of CONVERTING an ER Model to STAR Schema, you can downlaod and read CHAPTER 6, Section 6.1 of this IBM Book on Star Schema Design. The link is:


http://www.redbooks.ibm.com/abstract...7138.html?Open

This is an excellent IBM Redbook on Data warehouse design and Dimensional Modeling design.

Great to read,
Dave