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
- 6227 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thippareddy.p
if (drawtime)< 13 then drawtime=drawtime+12 else drawtime
| Is This Answer Correct ? | 18 Yes | 2 No |
SRC--->Transformer--->TGT
In the TFM Output Columns Derivations:
(HoursFromTime((MyLnk.drawtime:"00"))+12): MinutesFromTime(MyLnk.drawtime)--->OutputColumn
(MyLnk.drawtime:"00")--->Convert Source Format to %hh:%nn:%ss
(HoursFromTime((MyLnk.drawtime:"00"))+12)--->Adding 12 hours to hours from source and Concatanating with Minutes from Source.
| Is This Answer Correct ? | 1 Yes | 0 No |
wt is the difference between swith and filter stage
How to RD using transformer?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
Why we need datasets ratherthan sequential files?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
What is oci?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
What is the use of surrogate key stage?
What is the purpose of pivot stage and types of containers in datastage
Explain the situation where you have applied SCD in your project?
how to find no.of records in sequntial file itself?
What is the difference between SQl Loader and OCI in datastage?
Teradata 
