Interested to Buy Any Domain ? << Click Here >> for more details...
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
Which columns go to the fact table and which columns go the dimension table?
What are the steps involved in designing a fact table?
Explain the differences between normalizer and normalizer transformation?
What is difference macros and prompts?
Explain reference cursor?
What is surrogate key? Where we use it explain with example?
What is is a star schema?
What is difference between query studio and report studio?
Compare cold fusion with other programming languages?
what are different storage options supported by oracle ?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is data mart in data warehouse?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain grouped cross tab?
