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 are the functionalities of link collector?
What is the importance of the exception activity in datastage?
project Steps,hits, Project level HArd things,Solved methods?
Differentiate between Join, Merge and Lookup stage?
What is the command line function to import and export the ds jobs?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Name the different sorting methods in datastage.
How a server job can be converted to a parallel job?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How to reverse the string using SQL?
What are the components of datastage?
What is datastage?
What is quality stage?
What is process model?
What is the flow of loading data into fact & dimensional tables?