Answer / sudhakar

the main disadvantage of snowflake schema is its normalised
format, so performance is poor and it is complex.

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

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....

What are the types of containers?

0 Answers  

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 Answers  

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

What are the various kinds of the hash file?

0 Answers  

---

what is the main difference between sorragate key n primary key in one word

2 Answers  

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

What are the different common services in datastage?

0 Answers  

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---

What is the difference between validate and compile?

1 Answers   CTS,

---

Where do the datastage jobs get stored?

0 Answers  

---