Answer / suresh

above answer is wrong,correct answer is converting denormalized data into normalized data is called snow flake schema

Answer / srinu

one fact table is surrounded by different dimension table
and dimension table relation with master dimension table is
called snowflake schema (or) extended star schema

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

specify data stage strength?

1 Answers  

---

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

---

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

---

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

---

how do you pass parameters in a script?

1 Answers   L&T,

---