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

if you use oracle sql*loader , how do you transform data with it during loading?

2108

three ways sql*loader could load data, what are those three types?

1 4754

what are the others of "bad files" and "discard files" when using sql*loader?

2137

how do you use commit frequencies? how does it affect loading performance?

1 4569

what are the other factors of the database on which the loading performance depend?

1914

what is parallelism?

2 5206

what is parallel query?

2092

what are different ways of loading data to data warehouse using oracle?

1 5395

what is table partitioning? How it is useful to warehouse database?

EDS, IBM,

1 8559

what are different types of partitioning in oracle ?

3 11531

what is indexing ? what are different types of indexes supported by oracle ?

2 10809

what are different storage options supported by oracle ?

2093

what is query optimizer? what are different types of optimizer s supported by oracle ?

ABC,

1 13263

explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

IBM, Ness Technologies,

3 16460

Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

iFlex, Wipro,

1 5460

Un-Answered Questions { Data Warehouse }

Difference between cold fusion mx 6 and cold fusion mx 7?

842

What Is The Difference Between Oltp And Olap?

1130

What are the different models used in cluster analysis?

963

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4722

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1067

Give me any example of semi and non additive measures?

977

When we save a report in report studio with what extn it save?

1068

How we drill up week to month?

1079

How would you increase the logical size of a table in microstrategy?

976

How would you identify a macro variable? : sas-macro

1026

What is cost benefit analysis (cba)?

998

Target increases every day even though no new record was inserted

1589

Intern stastical programmer written test

760

Why do you get spool space errors? How do trouble-shoot them?

1060

To see hidden files in LINIX?

1532

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