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

what are the major three types of modeling used?

InfoAxon Technologies,

1112

what is an use case?

InfoAxon Technologies,

1088

Why should we use data ware housing and how can you extract data for analysis with example?

TCS,

1044

What is the purpose of Dataware Control?

CGI,

1095

What is conformed fact?

1150

What are the key columns in Fact and dimension tables?

1020

What is Star Schema?

Informatica,

1164

What are the types of SCD?

1281

What is VLDB?

1112

What are Aggregate tables?

1225

What are loops in Datawarehousing?

1053

How can we load the time dimension?

1250

What is a core dimension?

1115

What are Non-additive facts?

1218

What is real-time datawarehousing?

1075

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How to eliminate duplicate rows from flat file?

989

Explain what is real time data-warehousing?

1168

How can we run the graph?

1132

What are data modeling and data mining? Where it will be used?

1028

How can you communicate with web server (apache or iis) from coldfusion?

1190

What are loops in Datawarehousing?

1053

What is pre-emptive and non-pre-emptive?

1028

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1461

What are algorithms provided by Microsoft in SQL Server?

2109

Explain what are components of reportnet?

1025

What is the goal of optimizer?

1091

Can a dimension table contain numeric values?

1113

Explain what are data marts?

1196

Explain what are the advantages data mining over traditional approaches?

1206

Is union transormation is active transformation?

1021

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