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

Suggest a good author for hyperion in data warehousing?

963

What is metadata in context of a datawarehouse and how it is important?

1045

What is metadata in context of a datawarehouse?

1058

What is data warehosuing hierarchy?

1168

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

979

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

969

Explain degenerate dimension table?

1045

Explain the data type of the surrogate key?

948

Explain a linked cube?

955

Explain what are the methodologies of data warehousing?

926

Where we use surrogate key explain with example?

1125

Explain difference between snow flake and star schema.

1046

Difference between e-r modeling and dimentional modeling?

932

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1022

Explain what are the different types of data warehousing?

963

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are Aggregate tables?

1175

What are templates in which way it is help full?

995

How to drill through from a powerplay cube to reportnet?

937

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

903

Explain the difference between view and materialized view?

938

What is the function of surrogate key in data warehousing?

1063

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

967

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.

2236

Explain what is metadata reporter?

973

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

898

What are various warehousing tools?

1003

Explain what is the difference between view filter and report filter?

977

What is the metadata extension?

999

Which component has onread method and what it is used for?

984

What is recovering sessions?

936

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