Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What are the steps of implementing data warehousing?

510

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

531

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.

550

Ist the schema that a data warehouse system can implements.

475

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

438

What is drill-through?

553

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

492

Store (and count) non-fact records?

504

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

488

Define data warehouse?

533

How to pivot row data using informatica?

489

Why null values are mapped as 0 in fact tables?

516

What are the differences between datamart vs. Reporting cube?

459

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

509

List any five applications of data warehouse.

532


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a view as it relates to system modeling?

571


Explain me what are data marts?

565


What is meant by metadata in context of a data warehouse?

474


Explain why should you put your data warehouse on a different system than your oltp system?

491


What is Active Datawarehousing?

537






Can a dimension table contain numeric values?

570


What is an er diagram?

610


What needs to be done when the database is shutdown?

530


i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1569


What is conformed fact?

606


What is difference between query studio and report studio?

509


in general which algorithms for used?

1535


What is surrogate key? Where we use it?

549


What are components of reportnet?

574


Explain what is batch and describe about types of batches?

589