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 5082

How will you know the version of Bo using designer?

Tavant Technologies,

4 11124

What is slicing and dicing in business objects?

4 22238

What are the diffrences between Business Objects 5.1 & 6.5 ?

Siemens,

1 7032

What are the security level used in BO?

Oracle,

6 13741

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

Infosys,

2 10639

How to link two different universes ?

3 20931

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

TCS,

1 7092

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

2 13140

How does indexing improve query performance?

Satyam,

4 20886

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

Cap Gemini, Intel,

8 47604

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

3 7081

How to select the observations randomly from a SAS dataset

NTT Data,

7 27434

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

GSK GlaxoSmithKline,

8 21399

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 22712

Un-Answered Questions { Data Warehouse }

what is the Default Source Option For Update Strategy Transformation?

1250

can you tell me what are the dimension tables are used in project

2310

State the differences between shortcut and reusable transformation

1072

Explain what is the metadata extension?

1046

What is the need for an etl tool?

1078

What is a quality stage in datastage tool?

1088

What are the steps involved in the process flow of the sql statement through channel attached system?

1120

What do you understand by user class in cognos?

963

What could be the possible resons of locks by user?

1103

What is VLDB?

1076

what is sas business intelligence? : Sas-bi

1192

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1706

what is index?how it can work in informatica

2049

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1293

What is an unconnected transformation?

1098

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