deriving Month and Year to seperate columns

pxraja · Post by **pxraja** » Wed Aug 06, 2008 7:04 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Aug 06, 2008 7:08 am

The only way that no records are transferred is if you have a constraint expression. Please check this.

pxraja · Post by **pxraja** » Wed Aug 06, 2008 7:15 am

Hi Ray

Thanks for your reply

No Constraints used direct mapping

chulett · Post by **chulett** » Wed Aug 06, 2008 7:28 am

Describe your job design. Explain in detail what "no records has been transferred" means.