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
- 6795 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
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the difference between orabulk and bcp stages?
How to read multiple files using a single datastage job if files have the same metadata?
I have a few records just I want to store data in to targets cycling way how?
how to export or import the jobs in .ISX file
What is the differentiate between data file and descriptor file?
Can you define merge?
How can one find bugs in job sequence?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the enhancements made in datastage 7.5 compare with 7.0?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
what is flow of project?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the different type of jobs in datastage?
What is merge stage?
