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
- 6670 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
how to implement scd2 in datastage 7.5 with lookup stage
Difference between data warehousing and olap?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
sed,awk,head
What is process model?
What is apt_config in datastage?
Can we use target hash file as a lookup ?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How do you remove duplicate values in datastage?
What is the differentiate between data file and descriptor file?
What is aggtorec restructure operator?
What are the functionalities of link partitioner?
How do you schedule or monitoring the job?
What are the differences between datastage and informatica?
Which warehouse using in your datawarehouse
