Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

what is parallel query?

2091

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

1 5394

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

EDS, IBM,

1 8557

what are different types of partitioning in oracle ?

3 11529

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

2 10808

what are different storage options supported by oracle ?

2092

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

ABC,

1 13262

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

IBM, Ness Technologies,

3 16454

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 5456

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2120

How do you setup Lo-cockpit?

3169

difference between For each and for all

2 9446

Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

Accenture, IBM, TCS,

6 11585

Tell me one example for multi valued dimension or bridge table?

Accenture, CMC, IBM, Logica CMG, TCS,

2 19007

Tell me one example for junk dimension?

TCS,

9 45657

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How we are using this function?

1125

Tell me what is full load & incremental or refresh load?

952

Explain the different types of data warehousing?

994

Explain datawarehousing?

1052

What is analytical or analytic mean?

1128

How can we run the graph?

1073

What are the different types of schemas used in data warehousing?

953

What are the key columns in Fact and dimension tables?

981

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

2106

What is the difference between Datawarehouse and OLAP?

925

What is data warehosuing hierarchy?

1175

Explain what are the methodologies of data warehousing?

927

How can you communicate with web server (apache or iis) from coldfusion?

1121

What is data analytics in simple terms?

1194

What are the steps of implementing data warehousing?

1047

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