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?

2084

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 10801

what are different storage options supported by oracle ?

2091

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

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

2117

How do you setup Lo-cockpit?

3164

difference between For each and for all

2 9435

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 11577

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

Accenture, CMC, IBM, Logica CMG, TCS,

2 18998

Tell me one example for junk dimension?

TCS,

9 45642

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are data modeling and data mining? Where it will be used?

989

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

931

What are the fundamental elements of the data warehouse?

1001

Explain what is difference between query studio and report studio?

989

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

947

What is fact less fact table? Where you have used it in your project?

1011

What is difference between query studio and report studio?

1088

What are the stages of datawarehousing?

1013

What is the difference between snowflake and star schema?

1050

Explain what is fact less fact table? Where you have used it in your project?

933

Explain why fact table is in normal form?

970

Can we take backup when the database is opened?

1045

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1059

What is real-time datawarehousing?

1022

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1020

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