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?

 524

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

 542

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.

 564

Ist the schema that a data warehouse system can implements.

 488

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

 450

What is drill-through?

 566

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

 509

Store (and count) non-fact records?

 514

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

 501

Define data warehouse?

 546

How to pivot row data using informatica?

 504

Why null values are mapped as 0 in fact tables?

 525

What are the differences between datamart vs. Reporting cube?

 476

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

 521

List any five applications of data warehouse.

 546

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain vldb?

617

What are the approaches used by optimizer during execution plan?

475

What is Star Schema?

636

Difference between cold fusion 5 and cold fusion mx 6?

579

What is data analytics in simple terms?

545




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

646

Explain is olap databases are called decision support system true/false?

552

Explain what are non-additive facts?

552

What are the different types of scd's used in data warehousing?

561

Start a batches with in a batch?

545

Explain which are the olap tools available that are supported by oracle?

541

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2043

Explain me what is vldb?

515

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

558

Can we start and stop single session in concurent bstch?

517

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