DSXchange

Yes- There are tranformations done based on the return value of the function. I'll not be able to call the Fn. in source or target.
Deepali

Well, Yeah I remove ade's that point to my username on the DS server.
Thanks for pointing this out. Will be more careful.

In any case, is there a way I can solve my problem of being able to implement a function call in the job ?

Thanks,
Deepali

I've used Stored Procedure Stage and had the job working. But, for some reason having an SP in the job, brings the DS server to a crawl . When I do an ipcs I see a whole bunch of "0xade" memory segments still open, which I need to kill/bounce server to get the server to it's normal perform...

1) I will not be able to replicate the function logic within DS. The function is owned by another group, and we do not have visibilty to the underlying code. The purpose of the function is to get sales commission for a given Contract-Rep-TimePeriod. SELECT GetCommission(Contract,Rep,Period) pct FROM...

Hi, I am new to Datastage and have been struggling to get the Call to Oracle Function to work. Here's a sample flow in my DS Job ===================== Read from Source OCI Stage (5 columns)-> Send to Transformer Stage-> Manipulate Data (5 columns)-> Call Oracle Function that accepts 3 fields from th...