what is advantages of snowflake when it is used?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which r the connectors used in san?

1805


Could anyone give brief explanation bout datastage admin

1979


Differentiate between odbc and drs stage?

606


How the ipc stage work?

684


what is 'reconsideration error' and how can i respond to this error and how to debug this

2127






What is aggtorec restructure operator?

752


What a datastage macro?

650


In Datastage, how you can fix the truncated data error?

653


Nls stands for what in datastage?

738


What is datastage engine?

735


how to implement scd2 in datastage 7.5 with lookup stage

5143


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1642


What all the types of jobs you developed?

682


Can we use target hash file as a lookup ?

2828


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

547