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 to handle multi value dimensions?

2297

What are aggregate fact tables ? why they are needed? give an example

2 10721

State any 5 of Cods guidelines of an OLAP system, brief description each?

1 7195

what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 23330

Is there any difference in testing database and data ware housing?

2768

Are facts same as metrics and dimensions same as measures? If not , please tell the difference?

Patni,

1 8629

What is Grain & Granularity in Data Warehouse.

TCS, TVS,

2 46244

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.

IBM,

2240

IBM, MAHINDRA, Tech Mahindra,

4 8942

Disply the dname wise maximum salary

Principal Finance,

9 11844

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

Wipro,

1990

Is it possible to have more than one row on the same table with the same foreign key?

2 6478

Name at least three brands of Database Management Systems

1 4669

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

Wipro,

1 5786

Tell me the Top 10 features of oracle that supports datawarehousing.

CTS, IBM,

2 8076

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

For faster process, what we will do with the universe?

993

What is the difference between junk dimension and degenerated dimension?

1144

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

968

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

Explain datawarehousing?

1059

What is the limit to the number of sources and targets you can have in a mapping?

1111

What is the differences between star and snowflake schemas?

1071

How do you setup Lo-cockpit?

3172

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

977

How to load the time dimension?

1020

What is partitioning? What are the types of partitioning?

1172

What is meant by metadata in context of a data warehouse?

963

What are necessary tasks to install reportnet software?

928

Describe a data warehouse.

992

What is loop in data warehousing?

1150

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