DSXchange

waht is happening inside the transformer ? it would be better, if you share what the job is doing (you can support with a diagram of the job) please..

Hi Ray,

Could you please help me to understand the approach suggested by you.

In a similar case, I had already used the approach suggested by Chulett i.e using the hashed file.

Time to mark the topic as "Resolved" please

With Respect to DataStage, it is "HASHED FILE STAGE"...

Time to mark the thread as "Resolved"

Job1--<Check Trigger Condition>-->JobSeq_new---<Check the trigger condition>---->JobUpdateControlTable You can check the status of JobSeq_new... If all the 25 jobs, Job2 to Job 26 have finished , then only the status of JobSeq_new would be finished and the control will be transfered to the next ite...

Timestamp and OConv, IConv can be combined together to acheive the results...

time to mark the topic as "Resolved" please

aaha_naga wrote:Which thing is used to increase the performance in hash file stage?

"Enable write to cache" , "Preload file to memory" can be configured to enhance the performance of hashed file stage

Best would be to go through the Server Job Developer's Guide.

Is it possible to post the job design ? I mean the figure of the job design.. In case you want to trigger all job2 to Job26 in parallel , then you may create another Job Sequence and place all the 26 jobs in that.. but none connected to each other (so that they are triggered in parallel) . I am sugg...

Sample SQLs would help to understand the case better

The DELETE FROM TABLE will be efficient, if the table is EXCLUSIVELY accessible for the job that issues the DELETE FROM ... SQL. You may issue a LOCK TABLE < table name > IN EXCLUSIVE MODE (DB native formats may differ) as a Before SQL . Also, COMMIT must be issued after the DELETE is successful. To...

Check the "Tunables" settings for the project and the jobs.

Please mark the topic as "Resolved" if the issue is reolved

Adding to my last post only..
Start the loop with a default inital value and set the "To" value to a value returned by a routine. The routine will always increment the "To" variables value.

HTH.