DSXchange

Oracle Enterprise Stage is specifically for Oracle Database where as the ODBC is for Open Data Base Connectivity. There are some other Database stages like DB2/UDB, TeraData, Informix, Sybase.. etc which are Vendor specific and are designed to have good performance for that perticular database. Rela...

I guess..You can connect that reject link to another transformer and in that you will be able to specify the contraints to abort the job..

Are you running the job from a Job Sequence..?Many times I have seen that,If we run a job through a job sequence then the job will not show the performance statistics but it shows the performance statistics when ran individually..!!

Hi, I don't know the problem with LOAD,but you can use Write Method Upsert in both the target table instances. In TargetTable(Insert):Use insert then update & in TargetTable(Update): Use Update only.. And change the Constraints for output links in the transformer stage to suite your requirement..

Hi, I am assuming that there are some more fields in the target table for inserts and you need to update Recency_Id only everytime u get Arrangement_Id=0. While creating the table itself in the DDL give like create table XXX (----- -----, Recency_Id -- default 0, ---- ---); and change ur job design ...

Please check whether you are passing the correct values(matching parameters of the job sequence) in the Value Expressions to all the parameters(of the job) in your job activity stage. If everything is fine in the job activity stage then there will be no problem to override the default values of para...

Hi ArndW,
Thanks for your response...
We have n't done a force compile..

Hi, I have a Job which contains XML stages.The job was developed on v7.5.1 A and is running fine.When I tried to run the same job in v8.0.0.1 the job got aborted and gave the error: main_program: Fatal Error: Fatal: Shared library (xmli.so) failed to load: errno = (8), system message = (rtld: 0712-0...

Hi, When we tried to run the Job Sequences developed on v 7.5.1 A in version 8.0.0.1 the Job Sequences were aborted. The error messages are: 1) main_program: APT_PMConnectionRecord::rsh: fork failed, Resource temporarily unavailable main_program: APT_PM_LocalShell: fork failed, errno = 11 main_progr...

While running my job it is getting aborted after say some 100 iterations with an error saying GCI_LINK_INITILALISATION failure.I did n't found any fault in the design.
Any help..
Thanks.

How to make logs more informative like enabling some parameters of jobs in Administator,those can give more properties to look up on.

Any Help...


Thanks.

Hi,
How can I enabe some of the parameter in Administrator, that can give me more properties to look upon.


Thanks.

Hi,
How can we remove the status files for jobs in bulk in datastage director not by 1 job at a time.

Any Help,

Thanks