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 |
How to perform incremental load in datastage?
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How do you design PX Routines ?
What is the different type of jobs in datastage?
What are the processing stages?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
Why do we use exception activity in Datastage?
Describe link sort?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,