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 15126

What is XMLA ?

1 4407

What is Discover and Execute in XMLA?

2410

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

2 5203

What is a Data Cube?

1 6328

Explain in simple terms, the concept of Data Mining.

3 12945

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

iGate,

2138

which automation tool is used in data warehouse testing?

1 6332

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

1 6864

what is the difference between etl tool and olap tools

3 10748

what are the types of dimension tables

Infotech,

19 43745

What is a Data Warehouse?

9 12500

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

1 4085

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

Apex, ASD Lab, Bank Of America,

15 48802

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

5 11746

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is is a star schema?

1175

What is scd1 , scd2 , scd3?

1089

How do you create surrogate key using ab initio?

997

Can you state some of the innovations throughout history?

982

What are modeling tools available in the market?

978

What is a Decision Tree Algorithm?

5009

What is the difference between star and snowflake schemas?

1214

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1021

Explain how many ways you create ports?

1024

What is real-time datawarehousing?

1026

Where do we use semi and non additive facts?

992

What is cubes?

1075

Explain what is the difference between datawarehouse and bi?

971

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

1050

What is fact less fact table? Where you have used it in your project?

1011

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