DSXchange

Hi, We have been having problem with accessing the archived datasets. We are using unix tar command as follows to archive the datasets on daily basis. tar -cvf ${ARCHIVE_DIR}/${PROCESS_DATE}/stage.${BDATE}.tar -C ${STAGE} ./ All the datasets are written to sub-directories under ${STAGE} directory by...

I thank you all for great suggestions.

thanks
Suresh

Hi Shamail, Thanks for your response. The problem with null values is that the Datastage does not handle the null values and the job either fails with fatal run time error or drop (as it says in the log) the records. So it is recommended to handle nulls programmatically. As for the Timestamp is conc...

Hi, I have questions on my design approach. I am using Modify stage in my ETL process(es) to handle null values for various data types. I ended up having a modify stage whenever a database/file lookup is performed. That means I have a modify stage between lookup stage and database/file stage. The de...

lstsaur wrote:Read the stpstage.pdf file under the Doc folder.

Though I hard coded Oracle database connection related info, I finally got it to work. I need to find out how to use project level parameters for Oracle database connection related info. Thank you for directing me to pdf document.

thanks

1). STPPX property window has two main tabs "Stage" and "Input". The tabs under "Stage" tab with my questions are as follows. - General ==> I picked "Oracle" for Database Vendor. Then I was expecting to see the Oracle Stage connection options (Username, Passwo...

I am trying to design a job that uses "Stored Procedure" Stage to call Oracle Stored Procedure. I went through the DataStage documentation but I am unable to complete the job design. Here's what happened so far. - Added the Stored Procedure (STPPX) stage to my DataStage job. - Got confused...