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
- 13764 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the use of datastage designer?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the use of datastage director?
How can we improve the performance in datastage?
Explain Quality stage?
how to abort the job its matain duplicates?
Whats difference betweeen operational data stage (ods) and data warehouse?
How to RD using transformer?
What are the types of jobs we have in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Explain the situation where you have applied SCD in your project?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Can you implement SCD2 using join, transformer and funnel 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
