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?

2222

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

2 10605

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

1 7051

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

4 23133

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

2695

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

Patni,

1 8522

What is Grain & Granularity in Data Warehouse.

TCS, TVS,

2 46089

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,

2184

IBM, MAHINDRA, Tech Mahindra,

4 8790

Disply the dname wise maximum salary

Principal Finance,

9 11527

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,

1924

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

2 6345

Name at least three brands of Database Management Systems

1 4578

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

Wipro,

1 5683

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

CTS, IBM,

2 7933

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are aggregate tables and aggregate fact tables?

964

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

876

Explain the data types present in bo n wht happens if we implement view in the designer n report?

918

how much memory space occupied real time project (roughly)?

2180

What are the advantages and disadvantages of reporting directly against the database?

929

Explain degenerate dimension table?

986

How to create diff. Types of templates?

983

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

964

Which are the olap tools available that are supported by oracle?

884

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

928

What is conformed fact?

1040

What is data analysis? Where it will be used?

922

Explain what is the metadata extension?

980

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

863

Explain what are the various methods of getting incremental records or delta records from the source systems?

914

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