Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is the difference between constraind base load ordering and target load plan?

635

How to add a number to a macro variable?

543

What is the difference between drill through and masterdetail reports?

532

What is the difference between narmal load and bulk load?

1 693

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

522

What is the use of tabular model, tabular sql, tabular reference in real time application?

509

How many types of facts and what are they?

543

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?

535

Why we use repository connectivity?

534

The same tier?

533

What is recovering sessions?

533

How to define a cube??

538

What is prompt types of prompts?use of prompts syntax of prompt?

656

How to drill through from a powerplay cube to reportnet?

495

What is load manager?

561


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Which component has onread method and what it is used for?

498


What are the various transformation available?

558


How can we determine what records to extract?

589


What is the difference between datawarehouse and bi?

507


What is the extension of file to save template?

569






Explain what are the vaious etl tools in the market?

485


Explain the main differences between star and snowflake schema?

533


Suppose we want to display zero when null values coming to report how can we do that?

520


Explain what are non-additive facts in detail?

577


How to calculate fact table granularity?

568


How to create diff. Types of templates?

554


Explain how to export mappings to the production environment?

554


How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

551


What is partitioning? What are the types of partitioning?

568


What is the difference between olap and datawarehosue?

496