on 09-28-2015 11:25 AM
Hi All,
We have a requirement where the Time in source system(Oracle) is in "1/8/2015" format and it should be mapped to Target system (BPC) where Time is in "2015.JAN" format.
Kindly share your views on this.
Regards
Srikanth
Hi Srikanth,
I don't really see the issue here - the type on source and target are not the same.
So you can simply map
Time PER
1/8/2015 2015.JAN
Now, if that date changes (i.e. 1/8/2015, 2/8/2015, 3/8/2015) then it becomes more complicated. You would have to use either some string manipulation (Substring) or you map the 30/31 values of the month to the same target
Marc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Srikanth
You would get something like this:
As you can imagine, this will be terrible to maintain (365 lines, which need changing each year....)
I would recommend you customize something in DS, there you can do something with substr() and IF conditions
I.e something like
IF (substr(date, 1, 1) = "1" and substr (date, 5,4)="2015")....etc.
Marc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.