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...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?

Question Posted / vijayp.dw

Answers were Sorted based on User's Feedback



Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models ..

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

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models ..

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

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models ..

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

Post New Answer

More Data Stage Interview Questions

What is usage analysis in datastage?

0 Answers  

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

what is time dimension? and how to populate time demension

2 Answers   TCS,

what is hash file

2 Answers   CTS, IBM,

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

Define project in datastage?

0 Answers  

Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

2 Answers   IBM,

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories