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
- 6890 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 |
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
Whats difference betweeen operational data stage (ods) and data warehouse?
whats difference between ls -ltr and ls -lrt?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
how to call sequential generator in datastage?
why dataset ?
Difference between data warehousing and olap?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
whom do you report?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
How many types of sorting methods are available in datastage?
Teradata 
