Answer / kiran

any number of columns

Answer / kiransitams

any number of columns

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers  

---

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

What is the different type of jobs in datastage?

0 Answers  

---

---

What is the difference between in process and inter process?

0 Answers  

---

What are the different types of lookups in datastage?

0 Answers  

---

How can you write parallel routines in datastage PX?

0 Answers  

---

how will u design file watch jobs?

2 Answers  

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

count number of deptno in a emp table?

2 Answers   IBM,

---