1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category
Data Warehouse General Interview Questions
Questions Answers Views Company eMail

what is parallel query?

 1615

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

 1 4653

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

EDS, IBM,

1 7627

what are different types of partitioning in oracle ?

 3 10318

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

 2 9751

what are different storage options supported by oracle ?

 1598

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

ABC,

1 12543

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

IBM, Ness Technologies,

3 14878

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 4499

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

 1668

How do you setup Lo-cockpit?

 2620

difference between For each and for all

 2 8351

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 9448

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

Accenture, CMC, IBM, Logica CMG, TCS,

2 17724

Tell me one example for junk dimension?

TCS,

9 42890

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain the difference between oltp and olap?

671

Describe a data warehouse.

534

What is the use of tabular model, tabular sql, tabular reference in real time application?

507

What is drilling across?

547

Explain the difference between dw and bi?

509




Why is dimensional normalization not required?

608

What are the different types of segments?

534

What is data type of the surrogate key?

597

what type of raid setup would you put your tx logs?

519

Explain what is the data type of the surrogate key?

567

How can we determine what records to extract?

582

What is Active Datawarehousing?

548

What is static and local variable?

535

What are the reasons to use a chameleon method in data warehousing?

551

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

557

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