Interested to Buy Any Domain ? << Click Here >> for more details...
what is advantages of snowflake when it is used?
- 3 Answers
- 8070 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kishore
snowflake schema has normalized data i.e one dimension table
contains another dimension table like parent table and
child table
we can't get the data from child table directly i.e it
manitains secrecy
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raja sekhar
this can be used when the project data having the more number of devisions along with sub devision in one particular part of department. and more number of duplicated data is used for the project developmen. eg. pharma projects....
| Is This Answer Correct ? | 0 Yes | 1 No |
what is snow flack schema?
How to find value from a column in a dataset?
Define APT_CONFIG in Datastage?
How to Remove Duplicate using SQL?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
What is the difference between datastage and datastage tx?
what is the use of surogate key in datastage
How you Remove the Dataset in Unix?
how do you pass parameters in a script?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
What are some prerequisites for datastage?
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)
Teradata 
