DSXchange

Hi All, We have just done the installion of Datastage Px v8.5. I am trying to write a simple select subquery in oracle connector, its giving me a warning that oracle connector does not support subqueris. Also same warning giving for some simple funtions like trim, upper etc... Is any perticular patc...

You can do it as follows, 1. Use 2 different source to read the data i.e. A and B 2. Use column generator for each stream and generate a interger column named srno with initial value=1 and incremetal by=1 ( use these both column generator in sequencial mode). Also sort the input data using link sort...

While running a job I am getting a following error,
"main_program: Fatal Error: Duplicate class registration for: APT_CollationSeq"

Please help

In a simple datastage job in DS v8.5 I am writing two datasets X and Y. For both the datasets 'Update Policy=Overwrite'. job is able to write data in dataset X, but while writing data in dataset Y its giving error '.ds : Rename .ds to .ds.being_deleted failed.' Even I am not able to see the data fro...

May be you have to try with Windows 7 enterprice edition or else you can do it using Windows XP or Windows Server 2003 on VMWare. If you still get error related to MKS toolkit then try following steps, 1) Delete the InformationServer folder in c:\Program Files\Common Files\InstallShield\Universal\IB...

Hi All, We are planing to migrate the Datastage v7.5 to Datastage v8.1. In new environment (v8.1) we want to replace all Oracle EE stages with Oracle connector, so is there any converter or automation available to do it ( dont want to do it manualy, as approximate 1000 jobs are there). Thanks, Vinod.