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

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

915

What is static and local variable?

986

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

1032

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

873

Explain can a dimension table contains numeric values?

928

What is crass reference table?

1003

What is a fact, dimension, measure?

1104

Explain difference between e-r modeling and dimentional modeling?

926

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

876

Explain the definition of normalized and denormalized view?

845

Explain why fact table is in normal form?

933

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

946

Explain dimensional modelling?

923

What is batch processing?

978

What is aggregate fact table?

942

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Can we start and stop single session in concurent bstch?

893

What is vdl (view definition language) explain?

994

Explain difference between snow flake and star schema.

969

How to know the time taken for particular report execution?

915

What is difference between model & package?

985

Explain the definition of normalized and denormalized view?

845

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

933

What is type 2 version dimension?

917

what is an use case?

994

What is a data profile?

919

What needs to be done while starting the database?

1055

Where the cache files stored?

962

What is called dimensional modelling?

1041

Explain swot analysis?

1116

Explain what is the difference between olap and datawarehosue?

1044

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