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

What are the steps of implementing data warehousing?

 531

Explain about core dimension, balanced dimension, and dirty dimension?

 560

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.

 568

Ist the schema that a data warehouse system can implements.

 496

What is the very basic difference between data warehouse and operational databases?

 452

What is drill-through?

 572

How to pivot data using informatica when you have variable amount of pivot rows?

 517

Store (and count) non-fact records?

 517

What is many-to-many dimensional model in datawarehousing ?

 505

Define data warehouse?

 550

How to pivot row data using informatica?

 515

Why null values are mapped as 0 in fact tables?

 531

What are the differences between datamart vs. Reporting cube?

 481

What should I have in mind when building olap solution from scratch?

 527

List any five applications of data warehouse.

 550

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain grouped cross tab?

2193

What is cost benefit analysis (cba)?

583

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5262

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

528

Explain what is the advantages data mining over traditional approaches?

579




What should I have in mind when building olap solution from scratch?

527

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

518

What is the main difference between schema in rdbms and schemas in datawarehouse?

538

What is a core dimension?

606

What are the steps involved in designing a fact table?

489

Explain what is the difference between stop and abort?

538

Explain difference between view and materialized view?

505

What are necessary tasks to install reportnet software?

509

What is meta data and system catalog?

1849

what is difference between drill & scope of analysis?

525

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