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

1 6223

How can we import and export using BCP utility?

1 6411

What is Bulk Insert?

3 12491

What is DTS ?

1 5576

Can you brief about the Data warehouse project you worked on?

Deloitte, TCS,

2438

What is an OLTP (Online Transaction Processing) System?

4 9326

What is an OLAP (On-line Analytical processing) system?

1 5171

What is Conceptual, Logical and Physical model?

1 13203

What is Data purging?

TCS,

8 53364

What is Analysis Services?

2216

What are CUBES?

2 11187

What are the primary ways to store data in OLAP?

3 6339

What is META DATA information in Data warehousing projects?

IBM,

2 7589

What is multi-dimensional analysis?

Satyam,

3 5524

What is MDX?

TCS,

2 9360

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the steps to build the datawarehouse?

1086

How to drill through from a powerplay cube to reportnet?

990

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1087

What are the difference between snow flake and star schema?

1059

What we will do with the universe for faster process?

1028

What is "method/1"?

1151

What is called data cleaning?

1337

What is difference between query studio and report studio?

1151

What is a functional dependency f said to be minimal?

1162

What is surrogate key? Where we use it? Explain with examples.

1077

Explain why dimenstion tables are denormalized in nature?

973

what are the major three types of modeling used?

1112

What is Active Datawarehousing?

1057

What is the difference between data warehouse and operational systems?

1188

How to design file watch jobs?

1020

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