1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?

Question Posted / vijayp.dw

Answers were Sorted based on User's Feedback



Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models ..

Answer / ram

star schema is better
it will maintain denormalised data and also query
performance is faster because it having less relationships
between the tables

but in snowflake schema it is opposite

Is This Answer Correct ?    15 Yes 0 No

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models ..

Answer / 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

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models ..

Answer / 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

More Data Stage Interview Questions

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

Is it possible to query a hash file?

0 Answers   IBM,

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  




How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

client know skid info?

0 Answers   NTT Data,

How do you start developing a datastage project?

0 Answers  

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers   IBM,

what are the types of nodes

4 Answers   HCL, TCS,

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories