Hello All,
I want to convert the value to years by using (365.25 days = 1 year).
Can any one help me how this can be done in datastage parallel jobs.
Thanks
Pavan
Convert value to Years
Moderators: chulett, rschirm, roy
Convert value to Years
pavan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
Hi ,
By using transformer u can get this ..
But i need more clarification on this .
JOB:
Source ---->Trans------->Target
source:
---------
column1
194
2037
20438
32599
Transformer:
--------------
Stage variable: column1/365.25
Column1 : If floor(Stage variable) < 1 then 1 else floor(Stage variable)
Target:
u can get that..
let me know if its Wrong
Thanks
Manoj
By using transformer u can get this ..
But i need more clarification on this .
JOB:
Source ---->Trans------->Target
source:
---------
column1
194
2037
20438
32599
Transformer:
--------------
Stage variable: column1/365.25
Column1 : If floor(Stage variable) < 1 then 1 else floor(Stage variable)
Target:
u can get that..
let me know if its Wrong
Thanks
Manoj
Thanks for your reply....
in my source link data is coming form days say from (0-1000)...i want this to converted this to years by using by using (365.25 days = 1 year).
I have tried with above example with 10 records from 1 to 10...anf all the records giving me as 1.
My doubt here was how 1 day will be giving as 1 year afetr using the above logic...
in my source link data is coming form days say from (0-1000)...i want this to converted this to years by using by using (365.25 days = 1 year).
I have tried with above example with 10 records from 1 to 10...anf all the records giving me as 1.
My doubt here was how 1 day will be giving as 1 year afetr using the above logic...
pavan