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?

2100

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

1 4746

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

2132

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

1 4559

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

1911

what is parallelism?

2 5186

what is parallel query?

2083

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

1 5391

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

EDS, IBM,

1 8556

what are different types of partitioning in oracle ?

3 11523

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

2 10800

what are different storage options supported by oracle ?

2090

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

ABC,

1 13259

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

IBM, Ness Technologies,

3 16446

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 5451

Un-Answered Questions { Data Warehouse }

what is sas business intelligence? : Sas-bi

1180

How to create a cube in Transformer? What is the process? Please mention process thank u

1764

name the sub-tabs which are in advance tab of ti?

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1169

What would be the next step after collecting the data?

1191

Why we use surrogate key?

1235

What do you mean by caching in teradata?

1064

Explain the term 'columns' related to relational database management system?

1066

what is the difference between list and crosstab?

What is xml source qualifier transformation in informatica?

1217

what is document design in boxi,have u participate in that

2183

Can we collect statistics on table level?

1035

What do you understand by local lookup?

1161

Did you used proc test? when?

2039

Difference between star and snowflake schemas?

1152

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