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
What is the use of datastage director?
What is the difference between account and directory options ?
What steps should be taken to improve Datastage jobs?
What are routines in datastage? Enlist various types of routines.
What are the various kinds of the hash file?
I have a few records just I want to store data in to targets cycling way how?
Name the different types of Lookups in Datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Does datastage support slowly changing dimensions ?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the difference between informatica and datastage?
What are the important features of datastage?
What is quality stage?
How do you remove duplicate values in datastage?