Answer / sai

this forum helped me a lot to get more and more knowledge in Datastage particularly scenarios....i am following this forum from past 3 years.I got job in TCS and next CTS because of this forums...My technology is datastage and UNIX.thanks all

What is usage analysis in datastage?

0 Answers  

---

How many Key we can define in remove duplicate stage?

0 Answers   CTS,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---

how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,

---

What modeling tool do you use?

6 Answers   HP,

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

Define Merge?

0 Answers  

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

---

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 Answers  

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---