Data Warehouse General Interview Questions
Questions Answers Views Company eMail

How can we run the graph?

571

In a star schema, are foreign key constraints between facts and dimensions neccessary?

532

Fact table is in normalized or de-normalized form?

535

How can we do data cleaning?

576

What are fundamental stages of data warehousing?

527

What are aggregate tables and aggregate fact tables?

517

What is vldb(very large databases)?

535

What is the difference between view materialized view and view?

579

Explain datawarehousing?

547

What is operational data store (ods)?

553

Explain dimension table ?

550

What is bi?

557

Explain is fact table?

502

What are vaious etl tools in the market?

559


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What needs to be done while starting the database?

646


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1440


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

509


What are steps we have to follow in designing the userfriendly universe?

541


What is a linked cube?

529






What is dimensional modelling?

511


What is type 2 version dimension?

560


Difference between cold fusion mx 6 and cold fusion mx 7?

462


I need to set predefined condition. How I do this?

499


Explain why dimenstion tables are denormalized in nature?

506


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

495


Explain the structure of cold fusion?

575


How to eliminate duplicate rows from flat file?

500


What is batch processing?

567


How can we do data cleaning?

576