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
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 |
Explain entity, attribute and relationship in datastage?
Difference between server jobs & parallel jobs?
Name the different types of Lookups in Datastage?
What is the difference between lookup and sparse lookup?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
what is the use of DSattchJob?DetachJob? where can we find it?
Nls stands for what in datastage?
How did you reconcile source with target?
What is meta stage?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
What are routines in datastage? Enlist various types of routines.