what is advantages of snowflake when it is used?
Answer Posted / 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 |
Post New Answer View All Answers
Does datastage support slowly changing dimensions ?
What is datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Is it possible to query a hash file?
Define repository tables in datastage?
What are the different options associated with dsjob command?
how many rows sorted in sort stage by default in server jobs
What are the repository tables in datastage?
what is the use of materialized view?
how to abort the job its matain duplicates?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How can you write parallel routines in datastage PX?
On which interface you will be working as a developer?
What are stage variables?
why do u need the IOS upgradation in a FC switch