Answer / ranjith manda

row number column property in sequential file stage.

How do you load dimension data and fact data? Which is first

2 Answers  

---

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

---

Explain datastage architecture?

0 Answers  

---

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

What is orabulk stage?

0 Answers  

---

What is the purpose of pivot stage?

0 Answers  

---