DSXchange

try using shared container instead for calling the server routine from a transformer Shared Container option is fine when server routine is used for each of the record coming from input.But server routine is used only if there is no value found for a particular field inside the transformer.It is li...

I have one server routine to be called from transformer.As in parallel job normal transformer cannot call server routine I am thinking to use basic transformer instead.But as it reduces the performance a lot I want to know if any statistics is present where I can find how much the perfomance will ha...

chulett wrote:Can't you do that in the 'Open Command' area, or whatever it is called?

I have not tried that option but definitely look this option.

The Oracle oci stage is source stage. For target Oracle oci stage I can use Stored procedure stage before the Oracle enterprise stage in parallel job.For source oracle stage I am planning to use a script which will call the stored procedure in a before job routine.

I am trying to convert a server job to a parrallel job and in the server job in oracle oci stage one stored procedure is triggered before the sql query.Similar option is not present in Oracle Enterprise Stage.
If someone has any information on how to do this in parrallel job then please reply.

I have records coming like this into a transformer: Id1 Id2 Field 123 1 1 123 2 2 123 3 3 123 4 4 ................. ................ 234 1 1 234 2 2 .................. .................. I need first 11 records based on Id1 and Id2. Is there any way to do it in transformer. Thanks

I have to convert date in db2 table into integer in a query.Is there any function available for this conversion? The date format is mm/dd/yyyy and I want the number of days from a low date 01/01/0001.

Thanks,
Suman