Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Warehouse General Interview Questions
Questions Answers Views Company eMail

what is parallel query?

1178

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

1 4015

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

EDS, IBM,

1 6740

what are different types of partitioning in oracle ?

3 9210

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

2 8945

what are different storage options supported by oracle ?

1214

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

ABC,

1 11829

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

IBM, Ness Technologies,

3 13317

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 3636

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

1260

How do you setup Lo-cockpit?

2215

difference between For each and for all

2 7502

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 7232

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

Accenture, CMC, IBM, Logica CMG, TCS,

2 16468

Tell me one example for junk dimension?

TCS,

9 38759


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

Why facts table is useful in representing the data?

133


What is edw?

126


Explain what are the various methods of getting incremental records or delta records from the source systems?

125


What is operational data store (ods)?

137


Explain what is batch and describe about types of batches?

177






Explain dimension table ?

144


What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

145


How to load the time dimension?

132


What is a relationship?

129


How can we schedule the graph in unix?

147


Explain what are components of reportnet?

153


What is bi?

124


What is hybrid slowly changing dimension?

142


what are different storage options supported by oracle ?

1214


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1149