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 me what are conformed dimensions?

1029

Which columns go to the fact table and which columns go the dimension table?

961

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

1011

What is pre-emptive and non-pre-emptive?

977

Explain what does level of granularity of a fact table signify?

957

What is ods (operation data source)?

997

What is data validation strategies for data mart v?

1092

Explain what are fact, dimension, and measure?

992

Explain why denormalization is promoted in universe designing?

961

What is latest version of power center / power mart?

1057

What is partitioning? What are the types of partitioning?

1167

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

933

What is an er diagram?

1049

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

927

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1018

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

2271

Explain reference cursor?

2167

Explain piconet?

962

Explain what is analytical or analytic mean?

1017

I know of using applysimple, but there are other ways too?

960

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1955

Explain the importance of data warehouse?

1013

What are the steps involved in creating dimensional modeling process?

1021

What is a linked cube?

1006

Explain difference between snow flake and star schema.

1047

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

1049

What is surrogate key? Explain with examples.

1158

What is the difference between static cache and dynamic cache?

994

What is the difference between er modeling and dimensional modeling?

1149

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

911

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