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
- 13963 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
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is the sortmerge collector?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Define meta stage?
What could be a data source system?
What are the components of datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to delete one row in target dataset
What is a folder? Difference types of stages?
Describe the architecture of datastage?
Name the different sorting methods in datastage.
How a server job can be converted to a parallel job?
How complex jobs are implemented in datstage to improve performance?
What is the difference between an operational datastage and a data warehouse?
How to read multiple files using a single datastage job if files have the same metadata?
