Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
Answer Posted / 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 |
Post New Answer View All Answers
What are the main differences you have observed between 7.x and 8.x version of datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How do you register plug-ins?
What are the main features of datastage?
What are constraints and derivations?
What are the steps required to kill the job in Datastage?
What is a ds designer?
Explain connectivity between datastage with datasources?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is process model?
Have you used Unstructured data?
Explain usage analysis in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Which warehouse using in your datawarehouse