Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 5080

How will you know the version of Bo using designer?

Tavant Technologies,

4 11116

What is slicing and dicing in business objects?

4 22228

What are the diffrences between Business Objects 5.1 & 6.5 ?

Siemens,

1 7022

What are the security level used in BO?

Oracle,

6 13730

How to Implement the the Built-in Strategy Script in BO Designer?

Infosys,

2 10633

How to link two different universes ?

3 20926

How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

TCS,

1 7087

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 13135

How does indexing improve query performance?

Satyam,

4 20881

What is the diffrence between Multiload & Fastload interms of Performance?

Cap Gemini, Intel,

8 47589

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 7076

How to select the observations randomly from a SAS dataset

NTT Data,

7 27423

In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

GSK GlaxoSmithKline,

8 21394

How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take my question is how to use parameter value in the html page .)

JKL, Kudos India,

4 22709

Un-Answered Questions { Data Warehouse }

can we override a native sql query within informatica? How do we do it?

1133

-----------------What is Direct and Conventional loading?

2178

What do you mean by staging area?

979

What is the goal of optimizer?

1050

Define different types of attributes in microstrategy desktop?

1251

How do we execute sql file on redshift?

Can we access multiple operational databases from within a single microstrategy project?

1067

What are the advantages of raid 1, 1/0, and

980

According to you, what are the most important tables in a dw? Why?

992

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1119

Have you ever encountered an error called “depth not equal”?

1183

Can you use flat files in Mapplets.

2660

what are the all possible features supported modify stage?

2149

What happens when a node suffers a downfall?

1141

How to create diff. Types of templates?

1055

For More Un-Answered { Data Warehouse } Questions Click Here