what is advantages of snowflake when it is used?
Answer Posted / sudhakar
the main disadvantage of snowflake schema is its normalised
format, so performance is poor and it is complex.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe link sort?
Explain how a source file is populated?
how many rows sorted in sort stage by default in server jobs
What is difference between symmetric multiprocessing and massive parallel processing?
What are the partitioning techniques available in link partitioner?
What are the different options associated with dsjob command?
Difference between sequential file and data set?
Can you implement SCD2 using join, transformer and funnel stage?
how to add a new records into source?
What are the steps needed to create a simple basic datastage job?
What is usage analysis in datastage?
Define Data Stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Difference between data warehousing and olap?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)