Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is an error log table in informatica occurs and how to maintain it in mapping?

728

What is static and local variable?

737

What is the main difference between schema in rdbms and schemas in datawarehouse?

752

What is surrogate key? Where we use it explain with example?

653

Explain can a dimension table contains numeric values?

722

What is crass reference table?

788

What is a fact, dimension, measure?

752

Explain difference between e-r modeling and dimentional modeling?

737

Explain the definition of normalized and denormalized view and what are the differences between them?

692

Explain the definition of normalized and denormalized view?

682

Explain why fact table is in normal form?

699

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

706

Explain dimensional modelling?

709

What is batch processing?

765

What is aggregate fact table?

708


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the metadata extension?

720


Explain degenerate dimension table?

741


What is the difference between er modeling and dimensional modeling?

826


Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

779


Explain the difference between filter and conditin?

718


what is an use case?

789


What are the data types present in bo? What happens if we implement view in the designer n report?

721


What is the difference between view materialized view and view?

805


Can you state some of the innovations throughout history?

730


What are the different types of datawarehosuing?

734


How can you set the session management?

782


can anybody mail me the FAQS for hyperion essbase amd planning

5373


What is a real-time data warehouse?

740


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

1908


How to add a number to a macro variable?

732