Interested to Buy Any Domain ? << Click Here >> for more details...
what is advantages of snowflake when it is used?
- 3 Answers
- 8343 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 container and then types?
How can you find out whether datastage process is running or not in unix?
Can aggregator and transformer stages use to sort the data? How ?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
What are some different alternative commands associated with "dsjob"?
what is a message handler
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
how to sort two columns in single job in datastage.
How do you get log info into a file?
how to do pergformence tuning in datastage?
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
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
Teradata 
