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 6168

How can we import and export using BCP utility?

1 6330

What is Bulk Insert?

3 12388

What is DTS ?

1 5511

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

Deloitte, TCS,

2381

What is an OLTP (Online Transaction Processing) System?

4 9171

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

1 5112

What is Conceptual, Logical and Physical model?

1 13096

What is Data purging?

TCS,

8 53091

What is Analysis Services?

2149

What are CUBES?

2 11107

What are the primary ways to store data in OLAP?

3 6244

What is META DATA information in Data warehousing projects?

IBM,

2 7501

What is multi-dimensional analysis?

Satyam,

3 5417

What is MDX?

TCS,

2 9259

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is Discover and Execute in XMLA?

2417

What is data cleaning? How can we do that?

1047

What is data warehouse architecture?

1054

What needs to be done while starting the database?

1115

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1978

Explain the different types of data warehousing?

995

What is the data type of the surrogate key?

1006

Explain can a dimension table contains numeric values?

971

Explain multivalued dependency?

995

Fact table is in normalized or de-normalized form?

969

What is edw?

1204

What is data analysis? Where it will be used?

989

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

1025

Explain how to generate iqd file from framework manager?

950

What are the data types present in bo?

1134

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