Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What are the main differences you have observed between 7.x and 8.x version of datastage?

1025


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

1508


How do you register plug-ins?

922


What are the main features of datastage?

1208


What are constraints and derivations?

1114


What are the steps required to kill the job in Datastage?

1150


What is a ds designer?

1024


Explain connectivity between datastage with datasources?

942


If you want to use a same piece of code in different jobs, how will you achieve this?

1224


What is process model?

1921


Have you used Unstructured data?

1269


Explain usage analysis in datastage?

1098


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1141


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

1833


Which warehouse using in your datawarehouse

2117