Interested to Buy Any Domain ? << Click Here >> for more details...
Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 13816 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ram
star schema is better
it will maintain denormalised data and also query
performance is faster because it having less relationships
between the tables
but in snowflake schema it is opposite
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / chand
Star Schema is best choice...most of the project use star
schema. performance wise star schema is best.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / pavan
star schema is better than snow flake schema bcz star
schema maintained the denormalization its means allow
duplicates so i can say star schema is good
| Is This Answer Correct ? | 2 Yes | 0 No |
how to write server Routine coding?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
CHANGE CAPTURE
Hai..,in datastage how to explain project in interview?please explain any domain please.
deptno wise to find max and min,and sum of rows and in target to company wise maximum
How do you load dimension data and fact data? Which is first
Pls tell me what is troubleshooting in datastage view?
how can u handle null values in transformer stage.
what is the function in Transformer stage can act as Rank function in Oracle
what is initial load and incremental load
How do u set a default value to a column if the column value is NULL?
Teradata 
