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
- 13763 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a merge?
How we can covert server job to a parallel job?
why do u need the IOS upgradation in a FC switch
What are the stages in datastage?
What are the types of views in datastage director?
What are the functionalities of link partitioner?
How many Key we can define in remove duplicate stage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Define Job control?
What is a folder? Difference types of stages?
What are the job parameters?
Why we use surrogate key?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
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
How do you remove duplicate values in datastage?
