Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6891 Views
- I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
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 |
Post New Answer View All Answers
How do you import and export the datastage jobs?
Explain the situation where you have applied SCD in your project?
What is ibm datastage flow designer?
What are the job parameters?
what is the use of skid in reporting?
Can you filter data in hashed file?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What steps should be taken to improve Datastage jobs?
What is the precedence of stage variables,derivations, and constraints?
What are the various kinds of the hash file?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Define meta stage?
Define data aggregation?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to find value from a column in a dataset?
