DSXchange

No, I dont do any pre-sorting. The job is something like this, sequential file 1 ---> Oracle Enterprise 1 Change_capture--->Filter---> sequential file 2 ---> Oracle Enterprise 2 I dont know where exactly I get the error. Mostly it occurs even before the import from input files are done. :( Regards, ...

Laknar,
Your query give yesterday's date only. Moreover I think the requirement is in datastage and not oracle.

Regards,
Divya

You are going to use different jobs for the examples you mentioned right?

You can use differnt keys for different jobs and also within a single job.


Regards,
Divya

Does this give the date of last day or the 1st day of previous month? When I manipulate it, I get the 1st day of previous month. If its last day, can you explain me the logic?

Regards,
Divya

The required o/p is "mm/dd/yyyy hh:mi:ss AM " format. So slashes only will solve the issue. If there is still problem with the output data or if you get any error w.r.t conversion while running, let me know. There are few changes to be done w.r.t the job properties for Timestamp conversion...

Here are some of the frequent errros which we face: a.Fatal Error: waitForWriteSignal(): Premature EOF on node etlprd3 No such file or directory b.main_program: ORCHESTRATE step execution terminating due to SIGINT c.Fatal Error: Tsort merger aborting: Scratch space full d.Fatal Error: Unable to allo...

We get error related to "SIGINT" or "SIGKILL". Occasionally we get errors such as "output file full" or "scratch fill full".

Regards,
Divya

Breaking into smaller jobs is not possible as the job itself is a modular one. Increasing the resource availability is not possible as we do not have access and at the server side, they are not ready to increase the resouce size.

Regards,

Divya

Thanks for the prompt response

I understand that this option will reset the job(already in Abort state) and then run it if necessary, but if the job get aborted while running in the sequence, will be try to reset it and continue the sequence with the this job run??

Thanks in advance,

Divya

You can try any of the following depending upon your need. a. When you run the job ( from director/designer), the "Job run options" dialogue box will appear. In that choose the "Limits" tab, and select "No limit" option. This will stop your job from aborted unless there...

Where is the job-activity option??

Thanks in advance,

Divya

Hi, I need to know if a aborted job can be reset automatically via script/reset job(if any). I have a sequence scheduled to run daily. But certain jobs aborts due to lack of resources and once its reset and the sequence is re-started, it runs fine. Since the abort is frequent, I need to know if I ca...

I have used sequential file stage to read data more than 2GB. Not sure of the maximum size though.

Can you tell me the rough flow of your job (like what stages are used) ?

You can use Stringtotimestamp() function in the transformer stage for the conversion.

Ideally it will be something like:

StringToTimestamp(<input data>,"%yyyy/%mm/%dd %hh:%nn:%ss")

Regards,
Divya