Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
What are the features of datastage flow designer?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
In merge stage can we update the values?
In Datastage, how you can fix the truncated data error?
What is data partitioning?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
count number of deptno in a emp table?
how do u reduce warnings
What is the purpose of pivot stage and types of containers in datastage
What is the function in Transformer stage can act as Rank Function in oracle
How do you start developing a datastage project?