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 5188

How will you know the version of Bo using designer?

Tavant Technologies,

4 11309

What is slicing and dicing in business objects?

4 22425

What are the diffrences between Business Objects 5.1 & 6.5 ?

Siemens,

1 7113

What are the security level used in BO?

Oracle,

6 13937

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

Infosys,

2 10765

How to link two different universes ?

3 21069

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

TCS,

1 7163

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

2 13276

How does indexing improve query performance?

Satyam,

4 21040

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

Cap Gemini, Intel,

8 47883

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

3 7225

How to select the observations randomly from a SAS dataset

NTT Data,

7 27639

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

GSK GlaxoSmithKline,

8 21680

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 22835

Un-Answered Questions { Data Warehouse }

Explain the new features of teradata?

1094

explain the methodology of Data Warehousing?(Polaries)

2375

which date functions advances a date time or date/time value by a given interval? : Sas programming

1013

what is the role of transformer?

Can you explain the advantage of using shortcuts?

1081

Can you define confirmed dimension?

1146

I need to set predefined condition. How I do this?

1070

Is hadoop a etl tool?

1007

Explain the parallel data extension in teradata?

1158

What is the difference between static cache and dynamic cache?

1071

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2466

What are the challenges you faced while making of reports?

898

define drill through?

What are different deliverables according to phases?

3479

What is a passive transformation?

1155

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