DSXchange

Hi all I am getting following error when running the job with transformer stage. "Transformer_7: Failed to load the library "V0S7_PaRoutine_Transformer_7.so". Either the directory containing the library file is not on the library search path, or the library was compiled on a system th...

Can you elaborate more as how output is getting derived from input. Hi all, Here's the requirement that i'm facing: Can a Datastage process be designed for doing the following: Input file CHAIN CDE1 CDE2 CDE3 CDE4 AMT CNT 100, DM, N, N, BT, 300, 2 100, DM, N, N, AC, 200, 1 100, EM, N, N, BT, 100, 3 ...

Hi, I have one job having one sequential file generic stage and then sequential file. In genric stage I am calling transform operator. my Q is can we give input schema at transform opratore so that we overide the schema coming from input file. I have tried this but failed :cry: Can anyboduy guide me...

in documentation it is written that incoming data should be non partitioned. So if I have stage before surroget key stage(Active stage which means data will be partitioned/repartitioned) then I have to run this stage in sequential mode so that data will be non- partitioned before coming to surrdate ...

Where DO the rows go, given that you seem to be implying that they don't go where you expect them to? yes in my case when selector value are 2,1 then they are going to dataset label 2 when selector value are 3,10 then they are going to dataset label 1 so it is not behaving as I expected the input s...

in switch stage I have selected selectore mode as hash the documentation says following "Hash means that rows are hashed on the selector column modulo the number of output links and assigned to an output link accordingly" I am not getting what it does my job has 3 output link and selectore...

What is the functionality of combinality mode in Advance tab of stage? Where it can be useful?

Do your id(id with which you are running the job) has permission on the file.

Hi, Configuration of the DS server is SMP with 2 processors Following is the config file used { node "node1" { fastname "PUNACX010.xxxxx.com" pools "" resource disk "/u01/app/Ascential/DataStage/Datasets" {pools ""} resource scratchdisk "/u01/ap...

while reading from sequential file specify

null field value=''

I guess this will do

if you copy filepath and file name from job and go to unix did you able to cat the file.

just to add one more thing, you have to put same partition in second job while reading from dataset and upto aggregator stage so you need not sort again in job 2

following is our configuration file { node "node1" { fastname "pete1" pools "" resource disk "/u01/app/Ascential/DataStage/Datasets" {pools ""} resource scratchdisk "/u01/app/Ascential/DataStage/Scratch" {pools ""} } } we getting ...

hi, Thanks for all the inputs we have created the new project and server jobs are runnign fine but parrallel jobs are aborting due to following error

osh_conductor: You are not authorized to proceed! Job execution is being halted! Reason: Can't run jobs on conductor node

Any inputs on above error

hi,

Director log is showing compiled status even when we try to run the job. it is px job also if i try try to validate job nothing is happening it just show status of job as compiled. we have install datastage on linux platform.