Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

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

1 6743

What is staging area?

9 17354

What is data merging, data cleansing and sampling?

1 7730

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

2 5231

OLAP architecture?

CTS, Honeywell,

1 6038

What is subject area?

2 10625

Why do we use DSS database for OLAP tools?

3 10642

What is ?Data Warehousing??

Accenture,

3 6609

What are Data Marts?

2 5830

What are Fact tables and Dimension Tables?

IBM,

6 57373

What is Snow Flake Schema design in database?

3 8016

What is ETL process in Data warehousing?

3 17069

How can we do ETL process in SQL Server?

ETL,

1 7010

What is ?Data mining??

2 5470

Compare ?Data mining? and ?Data Warehousing??

5 10918

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain about core dimension,

985

What are the types of dimensional modeling?

1063

Explain the differences between normalizer and normalizer transformation?

1023

What is an error log table in informatica occurs and how to maintain it in mapping?

965

How can we run the graph?

1068

What is cfapplication tag?

971

What are the different types of data warehouses?

1084

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2271

Why is chameleon method used in data warehouse?

1166

What are partition points?

1073

What are the different types of data warehousing?

957

How to calculate fact table granularity?

1020

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1027

What is analytical or analytic mean?

1127

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

977

For More Un-Answered { Data Warehouse General } Questions Click Here