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?

703

What is static and local variable?

712

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

729

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

632

Explain can a dimension table contains numeric values?

703

What is crass reference table?

770

What is a fact, dimension, measure?

720

Explain difference between e-r modeling and dimentional modeling?

712

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

664

Explain the definition of normalized and denormalized view?

657

Explain why fact table is in normal form?

678

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

690

Explain dimensional modelling?

695

What is batch processing?

745

What is aggregate fact table?

687


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the design methods of data warehousing?

657


What is scd1 , scd2 , scd3?

822


How did you plan your Data ware house project?

1943


How to provide security in frame work manager for a query subject?

689


How to reduce warnings?

684






What is static and local variable?

712


Explain the difference between dw and bi?

674


What is a staging area? Do we need it? What is the purpose of a staging area?

722


I know of using applysimple, but there are other ways too?

703


What function should we use to display the value entered or selected by a user in response to a prompt?

668


What we will do with the universe for faster process?

711


What are modeling tools available in the market?

725


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

690


How to test report in reportnet?

737


What are the different ways to represent the loading of dimension tables?

656