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

How does data mining and data warehousing work together?

2 15250

What is XMLA ?

1 4475

What is Discover and Execute in XMLA?

2468

Give me a broad concept of what a data warehouse is, and what it might be used for?

2 5335

What is a Data Cube?

1 6410

Explain in simple terms, the concept of Data Mining.

3 13066

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

iGate,

2185

which automation tool is used in data warehouse testing?

1 6444

what is data validation strategies for data mart validation after loading process

1 6922

what is the difference between etl tool and olap tools

3 10864

what are the types of dimension tables

Infotech,

19 44230

What is a Data Warehouse?

9 12740

What is a ETL/ How does Oracle support the ETL process?

1 4170

What is the difference between a data warehouse and a data mart?

Apex, ASD Lab, Bank Of America,

15 49274

What is the difference between a W/H and an OLTP application?

5 11906

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

1191

How can we load the time dimension?

1250

What is core dimension?

1123

Explain why fact table is in normal form?

1018

What function should we use to display the value entered or selected by a user in response to a prompt?

1037

Which columns go to the fact table and which columns go the dimension table?

1020

What are vaious etl tools in the market?

1052

What are the possible data marts in retail sales?

1060

What are the various tools? Explain name a few?

1022

Explain what is partitioning? What are the types of partitioning?

1012

Explain if a flat file cotains 1000 records how can I get first and last records only?

966

What is the difference between power center and power mart?

1081

Briefly state different between data ware house & data mart?

1085

What are the different ways to represent the loading of dimension tables?

977

Explain what are the tasks that loadmanger process will do?

979

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