DSXchange

It got disqualified when they named a perfume thus.

If you're prepared to have the job abort, simply set a row limit on the output of a downstream Transformer stage. Go to the Constraints editor and enter an Abort After Rows value in the grid there. If you're not prepared to have the job abort there is no solution available. You could certainly restr...

chulett wrote:[raises hand] Umm... I'd like to be a Musketeer.

Artos, Porthos or D'Artagnan?

Do you have read cache enabled on all the Hashed File stages? DataStage will only consume the CPU it needs - this will be below 100% if it is waiting on events (such as I/O, waiting for COMMITs, etc.) As a test of this theory change your final stage to a Sequential File stage to see whether that mak...

Good idea.

So? This is meaningless outside the Untied States. And another thing. Why do you refer to gridiron as "football" when the ball never touches the foot of most players, and only rarely touches the foot of a specialist kicker for whom the whole game stops while they come on, have their kick, and go off...

You have more columns than column headings in your desired output. Please be more precise about the specification of your requirement.

Why do you want to? Surely if you convert it to a Date data type that's all you need to do. The Oracle Enterprise stage will accept a Date data type and process it properly.

Are you asking about N records on the left input, N records on the right input, or N records on the output? What precisely do you mean by "terminate"? The only way to terminate a job from within itself is to cause an abort. While this can be done, is it really what you want?

Just set NLS_LANG. Oracle needs it.

Add APT_STARTUP_STATUS and APT_PM_SHOW_PIDS as job parameters to learn how far into the startup your job gets. This message can indicate network problems but, given that it's player processes that are failing to start, I'd also suspect that the processing nodes may be too heavily loaded when the sta...

A perfect looking apple can still contain a worm. That the script "looks perfect" may simply reflect your inexperience. Please post the script. You might also include diagnostic echo commands in your script to verify that each command line argument and environment variable upon which it relies has b...

The appropriate stage type is Aggregator.

As noted MESSAGE_ID is, as it is presented, not a Decimal data type. You will need to apply an explicit conversion to convert it to Decimal and, even then, may exceed available precision. You might consider dfloat as a data type, but precision is no longer guaranteed. Given that it appears to be som...

Normal practice on DSXchange is, when you mark a thread as Resolved, to make a post indicating how it was resolved, to aid future searchers.

This thread already has a future searcher, namely amit_singh203.