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 |
What is Cleanup Resources and when do you use it?
What are orabulk and bcp stages?
What are stage variables?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
What is datastage engine?
Difference between the Sequence and Sequencer in DS?
what are the types of nodes
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
What are the primary usages of datastage tool?
What are some prerequisites for datastage?
How do u convert the columns to rows in datastage?