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?

1017

Explain multivalued dependency?

1041

Explain functional dependency?

1138

Explain what are the tasks that loadmanger process will do?

979

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

1222

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

1285

Explain the difference between dw and bi?

1110

Explain what is batch and describe about types of batches?

1131

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

1056

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

997

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

1087

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

1111

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

1077

Explain what are necessary tasks to install reportnet software?

972

What is difference between query studio and report studio?

1154

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain can report net connect multiple datasource at a time in report creation time?

981

What is VLDB?

1112

Explain the hierarchies level data warehousing.

933

Give some difference between oltp and olap.

1067

Can decision tree be implemented using SQL?

2173

What are various warehousing tools?

1072

What is the difference between constraind base load ordering and target load plan?

1157

What are components of reportnet?

1131

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

978

What is an er diagram?

1102

Explain what is full load & incremental or refresh load?

1032

What is hybrid slowly changing dimension?

1086

What is the difference between drill through and masterdetail reports?

1244

What is a functional dependency f said to be minimal?

1163

Explain what is partitioning? What are the types of partitioning?

1011

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