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
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
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Differentiate between hash file and sequential file?
Can you explain tagbatch restructure operator?
What is the method of removing duplicates, without the remove duplicate stage?
How one source columns or rows to be loaded in to two different tables?
Lookup constraints
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define meta stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How do u convert the columns to rows in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Describe link sort?
Why do we use link partitioner and link collector in datastage?
How you can fix the truncated data error in datastage?
What are the different options associated with dsjob command?