Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Explain ddl (data definition language)?

580

Explain how to generate iqd file from framework manager?

515

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

553

Code the tables statement for a single-level (most common) frequency?

476

What is perform recovery?

545

Can we start and stop single session in concurent bstch?

532

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

587

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

524

How to improve session performance in aggregator transformation?

534

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

577

What is a functional dependency f said to be minimal?

548

How to eliminate duplicate rows from flat file?

510

How to generate the cubes in framework manager?

554

What are target types on the server?

556

What is difference between model & package?

573


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between view materialized view and view?

593


Explain a relation schema and a relation?

593


How do you create surrogate key using ab initio?

547


How can we run the graph?

583


Where the cache files stored?

550






Describe a data warehouse.

548


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

516


How can we run the graph? What is the procedure for that?

511


What is bi?

574


Explain the main differences between star and snowflake schema?

546


Explain what is type 2 version dimension?

607


What is vdl (view definition language) explain?

647


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

650


What are the stages that are required in data warehousing?

520


what are the major three types of modeling used?

623