if (drawtime)< 13 then drawtime=drawtime+12 else drawtime

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

Question Posted / thippareddy.p

2 Answers
6889 Views
I also Faced
E-Mail Answers

Answer Posted / thippareddy.p

if (drawtime)< 13 then drawtime=drawtime+12 else drawtime

Is This Answer Correct ?

18 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2263

What are the repository tables in datastage?

1352

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2522

Triggers,VIEW,Procedures

1267

What is difference between server jobs & parallel jobs?

1091

What is the method of removing duplicates, without the remove duplicate stage?

1080

how to delete one row in target dataset

3166

Name the different sorting methods in datastage.

1106

what is the use of surogate key in datastage

2366

How to read multiple files using a single datastage job if files have the same metadata?

1306

Define Routines and their types?

1262

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

1269

What is "fatal error/rdbms code 3996" error?

1344

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

4052

What is the difference between the local container and shared container?

1145