Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9506 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkat
In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / koti
star schema is for simple data marts where as snowflake
schema for complexives...
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / senthil
hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..
star schema used in data warehousing ..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / radhakrishnansk
star schema is used for easy retrieval.
It is in 2nd normal form.
But snow flake is in 3rd normal form it needs more joins for
retrieval.
| Is This Answer Correct ? | 2 Yes | 3 No |
What is a mapplet/worklet in informatica?
How do you set a varible in incremental aggregation
what are the limitation of sorter transformation?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
What is the use of transformation?
What are teh different tasks that can be created in workflow manager?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the capacity of power cube?
Teradata 
