Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 12323 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how to implement scd2 in datastage 7.5 with lookup stage
what is the use of skid in reporting?
whom do you report?
How to read multiple files using a single datastage job if files have the same metadata?
What are the main features of datastage?
What is quality stage?
Highlight the main features of datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are some different alternative commands associated with "dsjob"?
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 difference between in process and inter process?
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
Explain connectivity between datastage with datasources?
Define Merge?
