DSXchange

xyz.sh: CONNECT: not found.
xyz.sh: DELETE: not found.
xyz.sh: COMMIT: not found.

In the shell script are you executing these ,SQL commands within the command center environment ??

suman , As per your reply "server routine is used only if there is no value found for a particular field " .This could be achieved using switch and merge stage . Also since you include a server job in a sequencer job along with parallel job , i would go with like ray has commented "do...

try using shared container instead for calling the server routine from a transformer

Good suggestion chullett . I guess that is more appropriate in his case. He can use this approach in case all records rejected are not getting processed . I prefer the other approach since i need to process some of the records which are also rejected , so that we can report those as data which has d...

One way is not to have a reject link ,but to have the reject critireon as the constraint in one of the output links .That will work . create a stage flag1. Have the expression return 0 if false otherwise return 1 eg: IF cond1 or (cond2 =2 and cond3=3) then 1 else 0 For the 4 output link write constr...

I would suggest you use HASH partition since it will partition the lookup data based on the keys you specify. If you set to auto there is guarantee that the input value and the corresponding lookup data will be in the same node . If youspecify entire same lookup data will be duplicated one for each ...

I dont think the assignment statement will be valid .write seperate derivations for each variables else you should be getting the expression in
red color

Try to get the select privleages as advised by dsguru2b . But in some situations we need to disable the constraints and enable the constraints later. You have to decide which is one is the best based on your specific
problem .

try disabling all the constraints on the target tables and select diasable constraints to false in the enterprise stage

please look into this directory where sqlldr log is stored .This is the
default directory

/var/dstage/Ascential/DataStage/Scratch

Hi Ray,

What i have noticed is lookup data is stored in this directory
/var/dstage/Ascential/DataStage/Datasets
and they get deleted after the job is complete . Any idea
where the dataset which is used by sqlldr is getting stored??

john

HINTS

You may need the 32 oracle client installed in your server . Also
check your environment setting in
/var/dstage/Ascential/DataStage/DSEngine/dsenv

I dont think you can have a reject link Oracle enterprise stage with load option . Try to create a reject link, it will say that it cannot create it because of lack of "output reject records property".You can always look into scratch directory to find why the data was not loaded

What i have noted ,it is the control files and log files for the enterprise stage which is stored here . If a job is running which is using this control file it will create issues . As far as i know i know there should not be any problem deleting these files(control and log files) if there is no job...

This error is because you are Appending data to a table which has the same key values defined in the constraint .If you truncate the target table and load the data this error should not occur