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

Explain what is fact less fact table? Where you have used it in your project?

870

What does level of granularity of a fact table signify?

1041

What are the different methods of loading dimension tables?

944

Explain what are the modules in power mart?

972

Explain what is ods (operation data source)?

929

Explain difference between data ware house & data mart?

931

Explain what is the difference between view filter and report filter?

920

What is data type of the surrogate key?

955

Where the applications and where ware house management system is used?

952

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

876

What is the difference between power center & power mart?

926

Explain what are conformed dimensions?

1024

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

902

How to calculate fact table granularity?

971

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1005

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5919

What is surrogate key? Explain with examples.

1058

What is a cube in data warehousing concept?

1016

What is a real-time data warehouse?

946

What is meta data and system catalog?

2238

What is mean by aggregate aware?

988

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

971

What is latest version of power center / power mart?

987

How can you set the session management?

1051

Explain er diagram?

935

How to add a number to a macro variable?

940

What are the reasons to use a chameleon method in data warehousing?

1000

Explain the difference between filter and conditin?

910

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

1034

How do you define data block size?

988

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