1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category
Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Explain what are the various transformation available?

 541

How to reduce warnings?

 527

What is the difference between a primary and secondary actor in use case modeling?

 585

Explain what is partitioning? What are the types of partitioning?

 515

Explain meta data?

 552

Explain why are oltp database designs not generally a good idea for a data warehouse?

 628

Tell me what is full load & incremental or refresh load?

 515

Explain is olap databases are called decision support system true/false?

 560

How can we determine what records to extract?

 599

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

 557

Explain which are the olap tools available that are supported by oracle?

 553

Explain some of modeling tools available in the market?

 526

Explain what are non-additive facts?

 565

Explain what is the difference between power center & power mart?

 528

Explain if a flat file cotains 1000 records how can I get first and last records only?

 535

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a hash cluster?

525

Explain bus schema?

549

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

493

What is the differences between star and snowflake schemas?

547

What are the different types of data warehousing?

521




Explain what is difference between query studio and report studio?

553

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

574

What is a data profile?

575

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

516

What is the difference between er modeling and dimensional modeling?

600

Explain what are necessary tasks to install reportnet software?

483

How can you clear the cache?

536

Explain the difference between oltp and olap?

686

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

543

What is difference macros and prompts?

1715

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