what is advantages of snowflake when it is used?
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 |
On which interface you will be working as a developer?
Define Job control?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
how can we do null handling in sequential files
WHAT IS FORCE COMPILE?
How to display errors in datastage?
Tell me the syntax of Configuration file?
What is use Array size in datastage
How to implement complex jobs in data stage?
How did you reconcile source with target?
how to handle null values using transformer stage?
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x