regarding DSTRANSFORMERS

[Saama]

hi gurus,

my design is odbc---->transformer--->odbc.

i have i/p column hiredate.

its format is 1980-12-17.

iam defining column properties as MONTH.TO QUARTER('HIREDATE')

will i convert months into quarter, will i able to view the quarters.

am i going in the right way.plz gurus help me.

cheers;
saama

[us1aslam1us]

On Page 20-6 of Ascential Datastage server job developer's guide, a brief description is given.

Sam

[narasimha]

If you check from the description of MONTH.TO.QUARTER Transform , you will find

Code: Select all

Converts string in MONTH.TAG format (YYYY-MM) to QUARTER.TAG format (YYYYQN).
Example: MONTH.TO.QUARTER("1993-02") => "1993Q1"

Is that what you want?

[Saama]

Hi gurus,

thanks very much , Actually i analyzed the property incorrectly.

Thanks very much.

cheers;
saama

[narasimha]

I guess this is more close to your requirement - TAG.TO.QUARTER

Code: Select all

Converts string in DATE.TAG format (YYYY-MM-DD) to QUARTER.TAG format (YYYYQN).
Example: TAG.TO.QUARTER("1993-02-14") => "1993Q2"

[us1aslam1us]

Code: Select all

Converts string in DATE.TAG format (YYYY-MM-DD) to QUARTER.TAG format (YYYYQN). 
Example: TAG.TO.QUARTER("1993-02-14") => "1993Q1"

Feb falls in first quarter.

Sam

[narasimha]

Code: Select all

Converts string in DATE.TAG format (YYYY-MM-DD) to QUARTER.TAG format (YYYYQN). 
Example: TAG.TO.QUARTER("1993-02-14") => "1993Q1"

Feb falls in first quarter.

Sam

Right, Thanks for pointing that out, Sam.
Looks like it is a documentation bug in this Transform's Description or sombody has modified its description in our company.

[ray.wurlod]

iam defining column properties as MONTH.TO QUARTER('HIREDATE')

The quotes around the input column name are incorrect.