Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is BCP?

1 5423

How can we import and export using BCP utility?

1 5308

What is Bulk Insert?

3 11147

What is DTS ?

1 4783

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

Deloitte, TCS,

1932

What is an OLTP (Online Transaction Processing) System?

4 7599

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

1 4335

What is Conceptual, Logical and Physical model?

1 12060

What is Data purging?

TCS,

8 50386

What is Analysis Services?

1628

What are CUBES?

2 10138

What are the primary ways to store data in OLAP?

3 5069

What is META DATA information in Data warehousing projects?

IBM,

2 6138

What is multi-dimensional analysis?

Satyam,

3 4147

What is MDX?

TCS,

2 8067


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

1906


Briefly state different between data ware house & data mart?

545


Explain a mapping, session, worklet, workflow, mapplet?

581


what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

1806


What is data analytics in simple terms?

541






How can you import tables from a database?

537


Explain the difference between dw and bi?

509


What is the difference between olap and datawarehosue?

494


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

550


What a static and local variable?

578


Explain how many ways you create ports?

599


Explain what is the difference between datawarehouse and bi?

511


Why is dimensional normalization not required?

608


After we create a scd table, can we use that particular dimension as a dimension table for star schema?

538


Explain what is difference between query studio and report studio?

531