DSXchange

Is it a remote database?
Try to write into a Sequential file directly.
Was there any other user accessing the same table. There can be the possibility of lock.

And yes, you can add those ErrorCodes which to be treated as warning/errors in the SP stage.

Other than 0 your job which calls the SP should thrugh out a warning.
In the job sequence, at the trigger part of Job Activity, you custom conditional to check whether the job state is DSJS.RUNWARN/ RUNOK.
If runok trigger the next job. Else trigger a 'Terminator Activity' to abort the flow.

Try running this job alone in the server.
What is the operation performed, it is select operation?
If so do the same from the command prompt, measure the time taken for that.
How complex is the query?
Where is the database situated?

HI,

The config file information is from 'Orchadmin' command and not from dataset descriptor file.

Hi Prasad,
Not necessary to post twice, Pls delete the other post.

This cannot be acheived by PIVOT stage. But by search.

Dont you have the option 'Automatically Handle Activity that fails' in Job property?
If so check it.

Oops.... I gone mad Its Vertical pivot. User Transformer. Have two output fields(AMT1 and AMT2). Expression for (AMT1) If DAY_ID = 1 Then AMT Else 0 Expression for (AMT2) If DAY_ID = 2 Then AMT Else 0 Use sort stage to sort based on EMP_ID. User aggregator to group on EMP_ID and find max for AMT1 an...

Again YYMMDD is not a date format. Pls go though the document. Date is a standard format. Else represent target as char again. If you want to convert into date use StingToDate((Inputlink[1,4]:'20':Inputlink[4,2]),"%DD%MM%YYYY") If you want to store it as char use Inputlink[4,2]:Inputlink[2,2}:Inputl...

Isolate your issue.
First try to replace the teradata stage with Sequential stage. Check whether the performance increses.
If yes, try to load your table with manual mode.
If rate of the speed changes, check the commit interval, transaction log, mode of your load.

HI Meena,
Could not get the exact picuture of you job structure.
Is the table and sequential file get populated in a same job.

Is the structure as JobActivity--->ExecuteCommand----->EmailNotification

Welcome Aboard :D Aggregatore have serveral option to find Standard Deviation, Mean , Variance.... You can try out the suitable option. Else use copy to have two link. One to find the sum(AMT_TOT_GOBLIG_PV_BOP) for that pool number using aggregator. Use join Stage with this output with the Non-Aggre...

Hope RPC is truned of, Project wise, Job wise, Stage wise.
Try doing Force compile.
Try Remaping.

If you schedule, It will prompt you for parameters. You can pass the different Invocation Id for each time as mentined.