Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Can we take backup when the database is opened?

569

What are the types of dimensional modeling?

601

What are the steps to build the datawarehouse?

575

What is execution plan?

736

What needs to be done when the database is shutdown?

542

Whether dimension table can have numeric value?

592

What are the steps involved in creating dimensional modeling process?

554

What is the difference between agglomerative and divisive hierarchical clustering?

639

What are the key features of chameleon that separates it from other algorithms?

662

What are the different types of schemas used in data warehousing?

509

What is the function of etl when used in data warehousing?

532

What is the purpose of cluster analysis in data warehousing?

554

Why is business intelligence (bi) important in data warehousing?

524

What are the different types of fact tables used in data warehousing?

548

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

554


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Where do we use semi and non additive facts?

578


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

481


What are the key columns in Fact and dimension tables?

538


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 ??????

1579


What are the types of SCD?

620






How to create prompts in report net?

549


Explain why denormalization is promoted in universe designing?

540


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

522


What are the various tools? Explain name a few?

531


What are the design methods of data warehousing?

501


What is called dimensional modelling?

570


What is a source qualifier?

515


What are target types on the server?

537


What is cubes?

610


How to performance tune reports?

567