DSXchange

HI, I have one question on ISNULL() function. I used ISNULL() function in transormer stage in few jobs to check the column value if it has null or not. First I tested jobs in test, all went fine.I moved code to production as is.out of three jobs 2 ran fine.one got aborted with error'' trying to setI...

Hi ,

my input data is like this sri@peoplesoft.com
Output shoud be like this peoplesoft.com
I used field(inputcolumn,"@",1,1)
But it is giving sri not peoplesoft.com

Can you please help me

Thanks

HI Ray,

It worked in Basic transformer stage.How can I get the same result in normal transformer stage.
First I read the timestamp as varchar.
In the normal transformer, I coudn't use mod function or to_char function
Could you please help me.

Thanks
Sri

Thanks Ray
It worked.

Thanks

Hi all,

Thanks for your Replies.Here I need to exclude only saturday and sunday.I am following Ray's suggested logic.Still I am working on that.
Thanks .
Sri

Hi,

I have one column, value is like this 2005-07-22 12:12:12
I need to add 3 businessdays to this filed.when I add 3 days to this timestamp output shoud be 2005-07-2712:12:12

Could you please help me with this.

Thanks in advance
Sri

Hi,


I have some questions regarding Ascential Integrity Tool.

I think it is used for cleansing data.Could anybody please tell exactly how it works ?How to clean data in the text files using ths toll.

Thanks
Sri

Craig and Ray thanks for your reply.It worked fine.

Hi,

I am using UV Stage to access hash file .But It is asking for dsn name ,user name and password.I am tring to access hash file that is created under account.Could anybody please help me.

Thanks
Sri

Hi Ray, Thanks for the valuable information. Welcome aboard! :D There are some databases, such as UniVerse and UniData, that allow you to have not just one value, but also more than one value in a column in a row. Typically this is a list of some kind, such as a person's qualitications or dependants...

Hi, I am new to DataStage.I am learning datastage by myself and dsxchange forum is helping me a lot.I have some doubts about multi-valued colmn in a hash file I read all questions and answers about multi valued column .Still I didn't get much.Could anybody please explain with simple job. Thanks Sri