how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

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  

---

how will u design file watch jobs?

2 Answers  

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

What are the steps required to kill the job in Datastage?

0 Answers  

---

What is the difference between lookup and sparse lookup?

1 Answers  

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---