DSXchange

You can also use DSMakeJobReport which will provide you the Job Status and the warning/error message.

When u created the shared container, u created the output link also ?

i think the problem is the output link from the shared container

The fastest way of loading data is using sqlldr with direct hint. Now it all depends on the situation whether to use direct hint or not. If you are creating data file and ctl file separetly then you need to trigger the sqlldr manually ( by wrinting code) so that point in time you can add different k...

You can have 1 additional parameter say InstanceId and that parameter can be reused every 3 hours or every day as the Instance number/ Invocation Id for the Job. This InstaceId would be passed while running the Job. if you have to run Job 8 times a day, then you may choose say from 1 to 8 as the Int...

u can create multiple sub-categories under Job and use it but i don't think that renaming the Job category itself is possible.

First of all, one thing should be noted. i.e. if we call a routine or use stage variable, the same logic would be implemented for both of these methods, that means we would be having the same code at both the places. So, if the code can be written and is not very complicated then the first choice wo...

U just need to reimport the metadata or add 2 more columns in your input stage and the problem would be solved

If u r changing dsenv, then u need to restart the Datastage Engine.

It's better if you identfy the records need to be inserted and records which needs to be updated. Then u may use sqlldr for Inserting the records with Append mode and can use ORACI stages to update the rest of the records with option update existing records only. This will definately give u a better...

Yeah, there is a limitation of size of a hash files. It can not grow beyond 2 Gb and infact ideally hash file should eb as small as possible. Now, there is a way around if u still want the hash file to grow more then 2 GB. u can make a hash file with 64 bit pointer and it can grow much much more tha...

In the contratint you have to write that wherever the HashFile(ColA) <> SeqFile(ColA). And u will get all the rows from Hash file which are not present in the Sequential File.

Reinstallation will most probably resolve the OLE errors. These errors are related with Client component and due to Windows Env.

I know a trainer who can provide the training on PX.
So if it is of ur interest and you are ready to pay then please send me a pvt message mr.nchincholikar

Very Rightly said by Arun Verma.

It is better you remove all unwanted special characters using routine.

when i am using ORACI9 stage in server job then i am able to read the source system, but when i am using PX then i am getting error.

Please suggest