Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 12694 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
Why do we use exception activity in Datastage?
How do you generate sequence number in datastage?
Difference between server jobs & parallel jobs?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is a datastage job?
Can you explain link buffering?
Describe stream connector?
what are the devoleper roles in real time? plz tell i am new to datastage....
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
In Datastage, how you can fix the truncated data error?
which r the connectors used in san?
What are datastage sequences?
Nls stands for what in datastage?
whom do you report?
What is use Array size in datastage
