DSXchange

Posted: **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

Posted: **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.

Posted: **Wed Aug 06, 2008 7:15 am**

Hi Ray

Thanks for your reply

No Constraints used direct mapping

Posted: **Wed Aug 06, 2008 7:28 am**

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

DSXchange

deriving Month and Year to seperate columns

deriving Month and Year to seperate columns