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
- 13762 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 a server job can be converted to a parallel job?
Triggers,VIEW,Procedures
Differentiate between operational datastage (ods) and data warehouse?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the enhancements made in datastage 7.5 compare with 7.0?
how to add a new records into source?
What is the use of datastage designer?
What are the types of hashed files in data stage
Describe the architecture of datastage?
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
What is meta stage?
How many areas for files does datastage have?
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 ?
How do u convert the columns to rows in datastage?
