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
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
How many types of stage?
What are stage variables, derivations and constants?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are constraints and derivations?
why do u need the IOS upgradation in a FC switch
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Explain the importance of surrogate key in data warehousing?
how many rows sorted in sort stage by default in server jobs
How to implement complex jobs in data stage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How many areas for files does datastage have?
How many types of views are there in a datastage director?
What is the difference between the local container and shared container?
What are the various kinds of containers available in datastage?