Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Explain Process flow in data warehouse??

BirlaSoft,

1 3516

if source contain 10records how you identify header and footer

Polaris,

2 5197

How to answer the question how many fakt table in your datawarehouse and what size it have?

Cap Gemini,

3 6106

Which one among Star and snowflake schemas will occupy more space?

Barclays,

1 6815

Why joiner transformation does not allow the aggregator transformation and expression transformation to join

2 7919

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1147

how to find unique records in informatica level

IBM,

1 2213

what is difference between scd2 and scd3

2 4234

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

IBM,

1146

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

387

Define Data Warehousing?

Wipro,

173

What is Operational Data Store?

Informatica,

169

What are diagrams?

InfoAxon Technologies,

151

what are relationships?

InfoAxon Technologies,

167

what are the different views that are considered when building an object-oriented software system?

InfoAxon Technologies,

178


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

Explain what are non-additive facts?

140


Explain is olap databases are called decision support system true/false?

131


How to create different types of templates?

134


What is the use of dimensional modeling in data warehousing?

125


Explain hybrid slowly changing dimension?

151






What are universe requirements?

145


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

127


What is Star Schema?

183


Explain vldb?

142


Explain the hierarchies level data warehousing.

144


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

140


Why is business intelligence (bi) important in data warehousing?

152


How do we design a universe?

134


How do you define data block size?

141


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

135