DSXchange

Hi, We have identified that this is due to DataStage not picking up the global Proxy Settings. The service user running DataStage is able to pick up the Proxy setting when outside of DataStage (we tested it outside of DataStage), but not when running DataStage. Any idea of what could be causing this...

Hi, I am trying to connect to AWS S3 from DataStage. I am using the S3 connector provided by DataStage to read/write from/to AWS S3. I am getting the following error when running the job: Unable to execute HTTP request: Connection to https://<bucket-name>.s3.amazonaws.com refused I am able to read/w...

There is a tool called IBM Cognos Data Manager Migration Assistant.

Demo here:
https://www.youtube.com/watch?v=YVHXNMB57t0

I think you need to install the latest Cognos patches to get it.

I have been told to use 'Start Connector Import Wizard...' to import metadata definitions using a saved data connection to enable Metadata Workbench later on for our project. The issue is when I iteratively importing the table definitions all the previous ones displays red mark (some king of error r...

Hi All, My Datastage 8.1 installation is sucessfull. I have create user and group also and asign role for datastage but when a try to connect administraction then I got following Error Message. "A communication failure occurred while attempting to obtain an initial context with the provider UR...

Cheers for the feedback.

James

Hi everyone, I am loading an Oracle table with an incremental set of data on a daily basis. Due to the nature of the incremental extract, some records will be new, some will be updates but many will be unchanged. I am planning to use the Change Data Capture stage to determine which of the incrementa...

All,

Thanks for the info.

Cheers,

James

Thanks Craig - any info anyone has would be most useful so we can plan for what we're going to do regarding versioning/deployment if and when we upgrade to Information Server and no longer have Version Control.

IOD is on in Sydney next week so hopefully I can quiz somebody from IBM when there...

We are told by IBM that in Information Server v8 the 'Version Control' application will no longer exist. Reading through dsxchange I understand that in v8.1 IBM will release a new deployment tool (as a replacement of 'Version Control'?). Has anyone got any more details on what this deployment tool i...

Hi, I feel you need to change the logic that Ray said, a little bit. Get the year and ordinal number of the day in the year according to Ray. Then u need to subtract one day from the ordinal number of the day calculated above and then use DateFromDaysSince function. Like, if value comes from src is ...