Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Explain ddl (data definition language)?

575

Explain how to generate iqd file from framework manager?

509

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

550

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

466

What is perform recovery?

538

Can we start and stop single session in concurent bstch?

526

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?

581

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

519

How to improve session performance in aggregator transformation?

526

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?

571

What is a functional dependency f said to be minimal?

546

How to eliminate duplicate rows from flat file?

505

How to generate the cubes in framework manager?

550

What are target types on the server?

550

What is difference between model & package?

566


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Tell me what is degree of a relation?

518


Which are the olap tools available that are supported by oracle?

517


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

535


What is the main difference between star and snowflake star schema? Which one is better and why?

554


What is a data profile?

571






What is the metadata extension?

537


Explain the main difference between inmon and kimball philosophies of data warehousing?

552


What are the different types of fact tables used in data warehousing?

554


How did you plan your Data ware house project?

1774


What is partitioning? What are the types of partitioning?

576


Explain what are data marts?

586


Explain have you ever been in a real dilemma at work? What did you do to get out of it?

531


How to create context?

595


What is data warehouse architecture?

578


What is difference between e-r modeling and dimensional modeling?

511