DSXchange

Guys,

I am having an interview to work in a client which uses DataStage.
I greatly appreciate if anyone can send me some practical interview questions.

Thanks & Regards,
Sesha

Thank you so much, ray. It works. I used as a Before Subroutine TCL command.

I , on an experimental basis, used the KeyMgtGetNextValue Transform as a sequence number generator. How do I reset this sequence? I used a number as the argument value for the SequenceName. Each time, I run the job, it is generating the numbers from where it last generated. How do I use a name as th...

Sorry, you should read it as compatible not comparible.

Can someone tell me if Datastage 5.2 on IBM AIX is comparible with Oracle 9.0.2 ? Thanks in advance.

Thank you so much Bland.

Hi,

I guess, I found the answer in DataStage Server Job Developer's guide.
The dsjob is the command to these tasks. I am not sure of the details, of course. Anyhow, any input / warnings in use of this are most welcome.

SK

Hi everyone,

I am new to Datastage. We want to know, if we can run jobs through operating system commands. Because, we will be using cron or ControlM for scheduling jobs.

Thanks in advance.

SK

Hi jseclen,

Thank you so much. It is just my beginning.
I just started to work with DataStage.
Really your answer was a great help for me to give some space requirements.

Regards,
SK

Hello, I am new to datastage. To start with, I want to know if I source data from an oracle table and load some summarized data into a target table, do I need a space on the datastage server for doing the summarization? Basically, it is a select with sum of some columns and group by some key columns...