DSXchange

Set the null field value in sequential file stage ...

The job for which you are trying to see the log is a generic job with multiple instance ??

Hi , Version : 8.0.1 OS : AIX I have a job for which multiple instance is enabled .Its a generic job used to populate 100 tables .So , We have 100 invocation id's .After running couple of times , I am unable to see the datastage log in the designer .When I am clicking the folder containing the gener...

Checking in director manually , Using dsjob -jobstatus or ps -aef | grep phamtom | grep -v grep | wc -l .

Check the datatypes in the control file ( .cntl ) and see if it is same as that of the data you are receiving ...

oracle enterprise stage by default uses single node to read the data .If you want to read in parallel then your table should be partitioned and you have select that option in stage .

Ray ,

How different oracle connector to oracle enterprise stage ?

without this variable , Still we can run the multi instance jobs with empty file right ? Could you elaborate the reason in using this variable ?

Check if you have the required permissions on the directories

ray.wurlod wrote:You should really change UVTEMP (a value in uvconfig) as well. ...

Hi Ray ,

Is UVTEMP in uvconfig file is same as that of TEMP_DIR ?

Thanks

-param param1=value -param param2=value -param param3=value -param param4=value

Use sort stage with key column change option and use transformer to concatenate

Sainath.Srinivasan wrote:If the database is same, then do the join within the source.

Else do a sparse lookup. ...

Hi Sainath ,

I think 500K input records may be high for a sparse lookup ...

Is there any optimal value on number of records for a sparse lookup ??

In Filter stage you can use like operator ...But i dont know how far you can use it in your requirement ..

As mentioned by craig , check if any locks are there at DB level

deepak ,

Can you tell what exactly your job is doing ? Is it writing into a oracle table ?