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  

---

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers   IBM,

---

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

How to Convert the columns into rows?

2 Answers  

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

How to clean the datastage repository?

0 Answers  

---

convert yyyy mm dd to dd mm yyyy?

4 Answers  

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

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,

---

what is normalization and denormalization

2 Answers   CTS,

---

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

10 Answers   IBM, iGate, TCS,

---

How to implement complex jobs in data stage?

0 Answers  

---