Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,

---

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  

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---

AGGREGATOR default datatype

0 Answers   CTS,

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

---

what is flow of project?

0 Answers   HSBC, IBM,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

How many types of views are there in a datastage director?

0 Answers  

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

Define APT_CONFIG in Datastage?

0 Answers  

---