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?
- 3 Answers
- 13680 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 |
How do you generate sequence number in datastage?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
job locking methods? How can we unlock the job?
What are the different types of lookups in datastage?
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?
Difference between JOIN,LOOKUP,MERGE?
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)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.
What are the different common services in datastage?
how many types of sorting the data in data stage?
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....
Define Merge?
Teradata 
