DSXchange

Hi All where are the username and password stored internally. we want to change the user name and password for our DataStage server 1st solution: re-install Data Stage with our new username and password 2nd solution: if we can find out where that file which stores the username and password internall...

Hi All We working on a project and the input data which we are handling is in ASCII format. The client want us to give him the migrated output data after DataStage Transformations in UTF-8 compatible format. Are there any features in DataStage which can make my output Data compatible in the required...

i have Recurring entries of the key on which i want to use.

either i got to put it in to a sequential file and merge the streams or put the data into the hash file with a different key if it is a different key i don guess it will allow me to look up on the key i wanted in the hash file

hi all i have a stream of data coming in from a hash file.i have a table which holds additional information for the stream of records coming in. i want to join both the streams of data based on a key. Solution 1:i could use a transformer and made my table as a refernce link and Lkup and fill the inf...

hi all
I understand that Datastage comes with some Oracle adapters. If you have any document that explains what the adapter is and what it does, please share it with me.
Does Datastage have any adapters for Oracle Apps Erp? If yes, then any document on that would also be helpful.

Looks great reply but suppose if i want to differentiate between different DBMS errors like 1) foreign key constraint failing 2)table not present 3)invalid table name I mean suppose if i want to differentiate between DBMS errors.are there any provisions for doing it. I guess if i have a consolidated...

hi i know this sounds pretty wierd, but we are getting our jobs getting compiled but they are not running. No message is available in the director job log. The job just doesn't run. We tried restarting the datastage server but it didn't help. Has anyone ever encountered something like this Any point...

we are able to get through with sqlplus.should we be changing something to import the table definitions in datastage manager.

hi all
we are trying to access a oracle database loaded on a different unix box.
we have our datastage on a differnt server and oracle database on a different database.

Any pointers how this can be done

Thanx and Regards
Pavan