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?

2131

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

1 5445

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

EDS, IBM,

1 8623

what are different types of partitioning in oracle ?

3 11661

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

2 10878

what are different storage options supported by oracle ?

2136

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

ABC,

1 13328

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

IBM, Ness Technologies,

3 16608

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 5521

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

2176

How do you setup Lo-cockpit?

3240

difference between For each and for all

2 9555

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 11782

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

Accenture, CMC, IBM, Logica CMG, TCS,

2 19114

Tell me one example for junk dimension?

TCS,

9 45908

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are fact, dimension, and measure?

1413

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

977

What is the main difference between star and snowflake star schema? Which one is better and why?

1080

Where the cache files stored?

1064

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

1190

Explain functional dependency?

1137

I need a good brd and uc template?

1145

What is meant by metadata in context of a data warehouse and how it is important?

1269

Explain what are the mapping paramaters and maping variables?

1138

What is the purpose of Dataware Control?

1095

What are the steps to build the datawarehouse?

1086

Explain what are components of report studio?

1175

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1104

What is conformed fact?

1150

Code the tables statement to produce a multi-level frequency?

1046

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