Answer Posted / swamy.l.n
1.IN A STAR SCHEMA IF A DENORMALIZE DIMENTION TABLE SPLITED
INTO ONE OR MORE DIMENTION TABLE RESULTS IN THE
NORMALIZATION OF DIMMENTION TABLE.
2.SINCE THE D-BASE DESIGN LOOKS LIKE A SNOW FLAKE
STRUCTURE.IT IS KNOWN AS SNOW-FLAKE(OR)STAR-FLAKE.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is meta data and system catalog?
How can you communicate with web server (apache or iis) from coldfusion?
What is data stream and data adaopter. Is it same are different? Explain?
What is the limit to the number of sources and targets you can have in a mapping?
What are steps we have to follow in designing the userfriendly universe?
What is the difference between constraind base load ordering and target load plan?
Explain what is partitioning? What are the types of partitioning?
What are the mapping paramaters and maping variables?
What are the types of partitioning?
Store (and count) non-fact records?
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
What is latest version of power center / power mart?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain what is the difference between stop and abort?
Why should we use data ware housing and how can you extract data for analysis with example?