DSXchange

Hi,

I have an requirement as to find the months between the first month and end month using a tranformer to load the measure for the corresponding month.

- Pavithra

Hi,

Please let me know how to create a routine that checks the DS Job status and Reset if the status of the job is Abort.

Regards
Pavithra

Hi,

thanxs for the inputs.

- Pavithra

Hi,

Please let me know how to Execute an Stored Procedure through a Batch Job without using a Shell Script.

-Pavithra.V

Thanxs.. for the suggestion.

Regards
Pavithra

Hi,

Please let me know how to create a Batch Job in DataStage that executes or call a shell script which in turn execute a Oracle Package by passing parameters to the shell script from DS Job.

Regards
Pavithra

Hi, I have an requirement to calculate a measure column based on another measure column residing in the same table. A lookup file has to be created so as to carry out the caluculation for the measure that has to be updated in the target table. As the Volume of data is about 30 million, Please let me...

Hi, Thanxs for the valuble suggestion. Please let me know whether including Link Partioner and Link Collector stages can this error can be over come. or Is there any other way in creating a Server Job for the same that can split the huge volume of data and process the same and load it in to the data...

Hi,

we have also set the reduced the commit level but still the problem persist. Is there any way to design the server job to overcome this error.

Regards
Pavithra

Hi,

A Sequencer should be created to populate the Stage Table First then check for null values in the stage table, If there is Null Values then the Job should Abort Else the Fact Job should be triggered. How can i achive the same in Data Stage.

Regards
Pavithra.V

Hi, To load about 8 millions of records from one oracle table to another table using OCI stage to TRANSFORMER to OCI stage. This takes almost 8 hoursfor insertion alone. I have transaction size set to 30000 and array size as 10000. when tried with ORA BULK Loader to insert the same amount of records...

Hi, We are facing performance issue while loading stage to target. While loading from source to stage, it is using look up tables and it is loading in approximately 10 minutes (volume is 1.6 million records, loading performance: 1500 - 2000 records/second). but when loading from stage to target, it ...