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
- 6800 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 |
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
how to create document in datastage?
what is hash file
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
What is the difference between Datastage 7.5 and 7.0?
Differentiate between odbc and drs stage?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
What are the different common services in datastage?
What is a merge in datastage?
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
Teradata 
