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 are the various file formats involved in reportnet?

868

Explain multivalued dependency?

930

Explain functional dependency?

1034

Explain what are the tasks that loadmanger process will do?

863

Explain what are the basic needs to join two sources in a source qualifier?

1019

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1163

Explain the difference between dw and bi?

969

Explain what is batch and describe about types of batches?

1030

Explain what are the advantages and disadvantages of reporting directly against the database?

959

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

857

Is there any default username & pwd for bo designer & supervisor?

963

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

960

What is the use of incremental aggregation? Explain me in brief with an example?

976

Explain what are necessary tasks to install reportnet software?

863

What is difference between query studio and report studio?

1038

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is data analysis?

899

What are the various transformation available?

962

What are parallel querys and query hints?

2177

Explain in detail abt measure objects? And what is the use of it? How to create it?

943

Explain me what is vldb?

877

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

1016

What are situations where snowflake schema is better than star schema when the opposite is true?

934

How to create context?

955

Can you brief about the Data warehouse project you worked on?

2317

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

921

How do we design a universe?

881

Fact table is in normalized or de-normalized form?

908

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2186

Can we take backup when the database is opened?

1002

How much data hold in one universe.

931

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