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
6763 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

What are the repository tables in datastage?

1291

what are the devoleper roles in real time? plz tell i am new to datastage....

2143

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2173

What are the different type of jobs in datastage?

1035

How to reverse the string using SQL?

1498

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1398

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2210

project Steps,hits, Project level HArd things,Solved methods?

2107

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2432

What is the difference between odbc and drs stage?

1077

how to implement scd2 in datastage 7.5 with lookup stage

5593

How many types of hash files are there?

1164

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2089

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1193

How many types of sorting methods are available in datastage?

1061