Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
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 |
difference between server shared container and parallel shared container
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the main features of datastage?
What is the difference between datastage and datastage tx?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
How can we do null handling in sequential files?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
With out using Funnel Stage, how to populate the data from different sources to single target
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
what r the stages mostly used in realtime scenarios
What can we do with datastage director?