DSXchange

Hi All, In our project, the following scenario arises. Data needs to be transformed as per the business rules. The source can be a flat file or an Oracle table. What are the prons and cons of using a 1) flat file for storing the data 2) Oracle table for storing the data. I guess the parameters for t...

Hi All, What are all the differences between routines and subroutines? As far as my understanding is concerned, both are a collection of BASIC statements which performs some logic. Routines will be called when the job runs and in the case of subroutines, these can be called before or after the job r...

Chulett,

Thanks a lot for the reply.

I'm really sorry for putting it twice. I misakenly clicked the submit button again when it was already submitting.

Hi All, When designing DataStage jobs, when will go for ODBC stage and when to pick stages with native support like Sybase Stage, Oracle OCI stage...etc. My understanding says that ODBC has the advantage that it is portable across multiple dtabases. The disadvantages are that it is limited to window...

Hi All, When designing DataStage jobs, when will go for ODBC stage and when to pick stages with native support like Sybase Stage, Oracle OCI stage...etc. My understanding says that ODBC has the advantage that it is portable across multiple dtabases. The disadvantages are that it is limited to window...

Thanks a lot Arndw.

Hi All,

Whether hash file stage is an active stage or passive stage?. My understanding says active stages are stages which perform processing tasks whereas passive stages do not do processing tasks and just offer services to the active stages. Please let me know.

Thanks,
Sumesh

Hi All,

Whether hash file is an active stage or passive stage?. My understanding says active stages are stages which perform processing tasks whereas passive stages do not do processing tasks and just offer services to the active stages. Please let me know.

Thanks,
Sumesh

Hi Kduke,

I was just trying to execute multiple commands.

I've a query. Whether the return code form the command will be written to the output file? It'd be great if you can clarify me.


Thanks,
Sumesh

Hi All, I tried to execute two TCL commands using Command Stage as SELECT * FROM DS_JOBS ; SELECT * FROM DS_JOBOBJECTS But I got the result of only the first command in the Output log file. The CommandRTN column shows the return value for the first command. But when I executed two OS commands using ...

Hi All, I'm using a command stage and I've specified a command as echo "XYZ" > File1.txt and I've specified the value for Output to file as LogFile1.txt The Disable output to log checkbox is not checked. Once I run the job, the File1.txt file contains the string XYZ, but LogFile1.txt is em...

Ray,

Thanks a lot for your clarification. Can you please elaborate your answer.

Cheers,
Magesh

Sorry Guys. Posting a question like 'What are the options available in DS Server and DS Admin?' may sound weird. Actually my friend works on DS. He is not able to understand what does the question mean? For eg: we have dsadmin command in DS Admin. Can it be considered as an option in DS Admin. Can a...

Sorry Guys. Posting a question like 'What are the options available in DS Server and DS Admin?' may sound weird. Actually my friend works on DS. He is not able to understand what does the question mean? For eg: dsadmin command in DS Admin.

Can anyone tell me what is meant by 'Options' here?