DSXchange

OConv in parallel jobs ?

Also make sure there are no period ('.') character in the trailing part apart from the spaces. Also check for the existence of non printable characters by finding the length of the string.

Could some one please explain what "runtime definition of the symbol " actually means ?

sharmabhavesh wrote:Also, please elaborate the first option you have specified.

The first option is not applicable in your case. when you have multiple files to be read and all share a specific pattern, only then you can go ahead with file pattern which is not in your case

Is the '$' prefixed to environment variables just to distinguish them from the user defined job parameters or is there any underlying reason ?

Datastage services are down, you need to check with your Datastage administrator to bring them up. every user accessing the server would be impacted

The counts shown by performance statics are not 100% reliable.
Which of your counts 325,826 or 40,729 is correct ?

for the accurate counts, when you have such anomalies always use column like LOAD_DT/UPDT_LAST_DT which capture the processing date.

Performance - Faster computation with least resources consumed :D

ray.wurlod wrote:Or do the summing in the Transformer itself.

summations in transformer Vs summations in aggregator

Could you please highlight the performance trade off amongst the two choices ?

what does it say when you run the command from unix ?

vamsi.4a6 wrote:I increased the APT_BUFFER_MAXIMUM_MEMORY value from 3145728 to 31457289 but still facing same problem?

I dont think this would help as you are just trigerring the command from datastage.

if you can do a view data successfully but when you run the job it says "dataset not found" most probably the parameters might be the cause.

Check the values for the path parameter when the job has run from director if its the same you are using for a "view data"

guess you have to eliminate the @FM ! from the command output

or is it a modelling issue where the target was supposed to be varchar ?

have a logical thought, how would datastage convert alphanumeric values into a decimal ? your data is not fit to be converted into a decimal, you need to have additional logic to strip off alphabets and then convert the remaining but it would rather be better to fix at the source itself by identifyi...