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

Answer Posted / thippareddy.p

Is This Answer Correct ?

18 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many types of stage?

1135

What are stage variables, derivations and constants?

1169

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3608

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2182

What are constraints and derivations?

1116

why do u need the IOS upgradation in a FC switch

2226

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

2132

Explain the importance of surrogate key in data warehousing?

1131

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

3935

How to implement complex jobs in data stage?

1055

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2228

How many areas for files does datastage have?

1085

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

1233

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

1044

What are the various kinds of containers available in datastage?

976