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 |
when we will use connected Lookup & Unconnected Lookup
I have 100 records how can I load at a time from the single time
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
what is the function in Transformer stage can act as Rank function in Oracle
how can you generate sequence number using only the sequential file stage?
How do you import and export the datastage jobs?
Nls stands for what in datastage?
plz tell me some dimentional and fact table names in banking project?
Where do you see different stages in the designer?
How to manage date conversion in Datastage?
how to cleansing data