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

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---

What are stage variables and constants?

0 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

What is the purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,

---

What are system variables and sequencers in datastage

0 Answers  

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

What are stage variables?

0 Answers  

---

how to write server Routine coding?

0 Answers   Eric,

---