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 15137

What is XMLA ?

1 4412

What is Discover and Execute in XMLA?

2418

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

2 5207

What is a Data Cube?

1 6333

Explain in simple terms, the concept of Data Mining.

3 12958

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

iGate,

2142

which automation tool is used in data warehouse testing?

1 6342

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

1 6871

what is the difference between etl tool and olap tools

3 10757

what are the types of dimension tables

Infotech,

19 43775

What is a Data Warehouse?

9 12517

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

1 4088

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

Apex, ASD Lab, Bank Of America,

15 48837

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

5 11756

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How are the dimension tables designed?

1010

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

977

explain about dirty dimension?

1181

What is the very basic difference between data warehouse and operational databases?

973

How to pivot row data using informatica?

967

Can you pass sql queries in filter transformation?

1023

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

949

What are aggregate tables and aggregate fact tables?

1041

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5975

Explain how to get the first 100 rows from the flat file into the target?

977

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

934

Explain what are fact, dimension, and measure?

995

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2246

Explain the versions of reportnet?

991

Why is dimensional normalization not required?

1096

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