DSXchange

Untill unless you are getting correct end date for all different combinations, your way of calculation is correct,

thanks,
Tom

convert the duration into number of days and add them to date in datetime format and this becomes the end date in your case. Make sure in what format the duration exists in your case.

Hi,
Why do you get DSP.Open error even though we are able to connect to database while pulling data from tables?

thanks,
latha

Hello,
How would you reset surrogate key value generated to load target table from stating number say '1' again? What's exact routine in Before job sub-routine or command used in DS Adminstrator?

thanks,
Tom

I am generating using KeyMgtGetNextValue(%Sequence Name%).
So if I delete all rows in target table, and run with source data. How to reset SK ID to start from id=1.

thanks,
Tom

How to reset SK value?

thanks,
Tom

Once a surrogate key is generated on an out row for a column, is this keeps on increasing even if we delete all data and reload.

Is there any way if we can generate from starting number after deleting all data from target table?

thanks,
tom

As you all know, Datastage comes with the add-in component "Director" for job scheduling. Why is it necessary to go for third party tools like "Autosys" or any other job scheduler.

your answers will be helpful

thanks,
Tom

What's difference between @INROWNUM and @OUTROWNUM in data stage system variables.

thanks,
Tom

What does Validating a job mean?

thanks

If the servers(Dev and Prod) are located on once box then no need to ex/im table definitions along with server job executables.

thanks,
Tom

I don't think to export data definitions when you are exporting/importing a server job from one server to other. Say from dev to prod box.

check DS Manager guide once.

thanks,
Tom

Resetting a job from either finihed state or from aborted state brings back the job in a stage to be able to recompile the job. Hence by resetting the job, we are able to bring back the job in a runnable state.

thanks,
Tom

Check to see if the container exists in the correct sub-directory in the Data stage jobs. or else the file you are referring through that container exists in correct path.

thanks,
Tom

Pivot stage and split the whole column into 3 cols

I never tried. Let me know if it gets results

thanks,
Tom