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 6048

How can we import and export using BCP utility?

1 6219

What is Bulk Insert?

3 12200

What is DTS ?

1 5402

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

Deloitte, TCS,

2315

What is an OLTP (Online Transaction Processing) System?

4 8907

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

1 5017

What is Conceptual, Logical and Physical model?

1 12962

What is Data purging?

TCS,

8 52720

What is Analysis Services?

2058

What are CUBES?

2 10970

What are the primary ways to store data in OLAP?

3 6064

What is META DATA information in Data warehousing projects?

IBM,

2 7343

What is multi-dimensional analysis?

Satyam,

3 5261

What is MDX?

TCS,

2 9098

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are data modeling and data mining?

1033

What is the difference between connected and unconnected stored procedures?

987

What are aggregate transformation?

989

Why we use repository connectivity?

923

What is degenerate dimension table?

944

How we are using this function?

1043

Explain datawarehousing?

1000

What is the use of incremental aggregation? Explain me in brief with an example?

976

How to stop a batch?

914

Tell me what is full load & incremental or refresh load?

888

What is scd1 , scd2 , scd3?

1034

Can you state some of the innovations throughout history?

929

What are templates in which way it is help full?

936

What are the data marts?

917

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

920

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