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?

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

How do you generate sequence number in datastage?

0 Answers  


3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  


job locking methods? How can we unlock the job?

3 Answers   IBM,


What are the different types of lookups in datastage?

0 Answers  


how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,


Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,


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.

1 Answers  


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  


What are the different common services in datastage?

0 Answers  


how many types of sorting the data in data stage?

1 Answers   BoA, IBM,


when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,


Define Merge?

0 Answers  


Categories