1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category
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?

 561

What is static and local variable?

 557

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

 539

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

 485

Explain can a dimension table contains numeric values?

 563

What is crass reference table?

 593

What is a fact, dimension, measure?

 553

Explain difference between e-r modeling and dimentional modeling?

 560

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

 520

Explain the definition of normalized and denormalized view?

 523

Explain why fact table is in normal form?

 538

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

 530

Explain dimensional modelling?

 542

What is batch processing?

 581

What is aggregate fact table?

 529

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is recovering sessions?

538

Explain what are components of reportnet?

552

How to calculate fact table granularity?

573

How to limit the max no of rows retrieved in the report?

549

Explain degenerate dimension table?

537




what type of raid setup would you put your tx logs?

523

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1536

What are the difference between snow flake and star schema?

509

Explain why denormalization is promoted in universe designing?

548

What is meant by metadata in context of a data warehouse?

491

Can you state some of the innovations throughout history?

546

What is the difference between aggregate table and materialized view?

596

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

537

Where do we use semi and non additive facts?

584

What is the definition of cube in datawarehousing?

553

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