Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

Can we take backup when the database is opened?

1045

What are the types of dimensional modeling?

1064

What are the steps to build the datawarehouse?

1040

What is execution plan?

1202

What needs to be done when the database is shutdown?

1026

Whether dimension table can have numeric value?

1149

What are the steps involved in creating dimensional modeling process?

1021

What is the difference between agglomerative and divisive hierarchical clustering?

1185

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

1118

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

950

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

960

What is the purpose of cluster analysis in data warehousing?

1008

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

943

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

994

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

1247

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the goal of optimizer?

1049

Explain the hierarchies level data warehousing.

885

Explain Association algorithm in Data mining?

2308

What is data type of the surrogate key?

1001

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

1986

Explain the importance of data warehouse?

1013

What are fundamental stages of data warehousing?

1046

What is a data profile?

974

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

960

Explain what is a view as it relates to system modeling?

987

Explain what is type 2 version dimension?

1007

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1061

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

1009

what are the different views that are considered when building an object-oriented software system?

1031

Difference between cold fusion 5 and cold fusion mx 6?

995

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