Hi all,
I am trying to derive from source field whose datatype is varchar2 i.e, for example,
Inlink.field0
Mar 08
Jun 08
Jul 08
Outlink.Field1 Outlink.Field2
MARCH 2008
JUNE 2008
JULY 2008
I am trying to achieve using Oconv & Iconv as column derivation
Oconv(Iconv(UpCase(Inlink.field0),"D MY[A3,2]"),"D M[A]") mapped to Outlink.Field1
Oconv(Iconv(UpCase(Inlink.field0),"D MY[A3,2"),"D Y[]") mapped to Outlink.Field2
while I am running the job no records has been transferred also no error is coming.
Can anyone help me in resolving this
Thanks in Advance
deriving Month and Year to seperate columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: