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?

941

Explain multivalued dependency?

992

Explain functional dependency?

1092

Explain what are the tasks that loadmanger process will do?

927

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

1142

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

1228

Explain the difference between dw and bi?

1048

Explain what is batch and describe about types of batches?

1080

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

1003

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

910

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

1031

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

1039

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

1023

Explain what are necessary tasks to install reportnet software?

932

What is difference between query studio and report studio?

1088

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what are fact, dimension, and measure?

992

How can you set the session management?

1123

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?

1071

What is the very basic difference between data warehouse and operational databases?

968

Explain can a dimension table contains numeric values?

967

What is metadata in context of a datawarehouse?

1060

What is the function of etl when used in data warehousing?

962

Explain difference between snow flake and star schema.

1050

How are the dimension tables designed?

1001

I need a good brd and uc template?

1087

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1099

Explain vldb?

1037

What is the difference between er modeling and dimensional modeling?

1150

Which component has onread method and what it is used for?

984

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1056

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