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

what is the difference btw proc means and proc univariate?

HSBC, TCS,

8 51988

What is the difference between running total and sub-total?

5 22098

How can we performance tune reports?

1 9928

What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?

Perot Systems,

3 10000

what is data cubes??

2 5302

What are the different types of Filters available in BUSINESS OBJECTS?

3 20449

what is canned universe and canned reports in bo?

1 10192

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

Cap Gemini, Deloitte,

6 23973

How would I achieve Traffic Lighting in Business Objects

Virtusa,

3 8533

What is the difference btw reportnet - Report studio and cognos 8 - Report studio

Dominion,

3 9332

How can we find out cardinality between two tables?

Dominion,

3 10388

what are determinants?

Dominion,

4 12290

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

TCS,

2080

what is difference btw summary filter and detail filter, plz explain with example

IBM, TCS,

10 54318

What is difference between rename and lable in sas?

Satyam,

10 31608

Un-Answered Questions { Data Warehouse }

Describe what the SQL Server tempdb and tlog files are used for?

2353

Explain joiner transformation in informatica

1137

what are the uses of fact table and dimension table in banking project?

4569

Mention what the difference between “look-up” file and “look is up” in abinitio?

1323

where to store informatica rejected data? How to extract the informatica rejected data?

1016

Name different type of objects in microstrategy?

943

What are the implications?

1725

What are the advantages of informatica?

1023

How many types of nodes supported by Redshift and what are the functions of nodes?

What is air-project parameter ?

2235

What is MPP. Is Redshift support MPP?

What is a merge in datastage?

1280

name some data transformation used in sas di? : Sas-di

984

Difference between nodup and nodupkey options?

1205

What is the difference between using drop = data set option in data statement and set statement?

1170

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