Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is difference between a connected look up and unconnected look up?

1 6067

What is staging area?

9 14529

What is data merging, data cleansing and sampling?

1 6896

What is up date strategy and what are th options for update strategy?

2 4185

OLAP architecture?

CTS, Honeywell,

1 5249

What is subject area?

2 9420

Why do we use DSS database for OLAP tools?

3 9298

What is ?Data Warehousing??

Accenture,

3 5347

What are Data Marts?

2 4977

What are Fact tables and Dimension Tables?

IBM,

6 55037

What is Snow Flake Schema design in database?

3 6691

What is ETL process in Data warehousing?

3 15837

How can we do ETL process in SQL Server?

ETL,

1 6169

What is ?Data mining??

2 4523

Compare ?Data mining? and ?Data Warehousing??

5 9403


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain the definition of normalized and denormalized view?

515


How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

576


Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

526


What is Operational Data Store?

589


Explain about core dimension,

530






I have two universes created by two difference database can we join them in designer & report level? How

524


What according to you might be the future of data warehousing?

520


Explain what are slowly changing dimensions?

603


What is the main difference between schema in rdbms and schemas in datawarehouse?

533


How can you communicate with web server (apache or iis) from coldfusion?

538


Explain what is a three tier data warehouse?

537


What is a real-time data warehouse? How is it different from near to real-time data warehouse?

541


What are the advantages and disadvantages of reporting directly against the database?

535


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?

534


What is "method/1"?

584