DSXchange

I am in the process of switching from Oracle OCI stages to Oracle Connector stage in my SERVER jobs. I have come across a difference in the way the Connector stage handles rows with a duplicate key. I would like the Connector to work the same as the OCI stage. The OCI stage throws a duplicate key wa...

Does my operations db have to called DSODB or can I use a different existing Oracle schema name? How to specify that name? I'm guessing that if I can change it it would be in the DSODBConnect.cfg file.

I hope I can do a good job of describing my issue. I am still a little confused myself. I am currently switching my DataStage Windows 8.01 instance to Linux 64bit 8.7 version of DataStage. I have a number of server jobs that use a sequential stage to create a file on a Windows UNC share. For example...

I am new to IA and recently just installed 8.5. Please excuse me if the answer to this question is obvious. I am trying to set a table that I analyzed 79 of 81 column as a baseline. According to the IA manual: On the Investigate navigator menu in the console, select Baseline Analysis. Select a table...

Yes, the truncate and the insert seems to be working. However, I get a fatal error but the job continues and completes.

The exact error is:

HRO_LOCATIONS: Query execute failed

Where HRO_LOCATIONS is the name of my sql server target stage.

Thanks Craig. I got some other error message (Query execute failed) but the insert seemed to work. I guess I still need to get used to parallel jobs.

I can set the "Write Method" property = Write, then the stage allows me to set the "Write Mode" = Truncate. However, then the SQL property goes away so I'm not able to enter my insert statement. I must be missing something. I don't see any before/after SQL tabs/properties either.

I am new to Parallel jobs an was wondering how to Truncate a SQL server table before I insert. I'm using the enterprise SQL Server stage. I have tried searching for this answer but could not find this topic.

For those who care, here is the resolution to the problem.

The environmental variable Parallel\Reporting\APT_PERFORMANCE_DATA was set to False. Evidently, it needs to unset (blank).

For those who care, here is the resolution to the problem.

The environmental variable Parallel\Reporting\APT_PERFORMANCE_DATA was set to False. Evidently, it needs to unset (blank).

windows

No, it's not the name of my file. My file name is: G:\dev\sdw\Temp\one.txt and my error message is: ##E IIS-DSEE-TCOS-00037 14:26:46(011) <main_program> Failed to open performance file False/performance.5144; The only thing that changes in the error message is the timestamp (14:26:46) and the number...

The job ftp's a file. It originally had a sequential stage linked to a sftp stage. The file property used parameters to build the path. I was not able to view the data of the source seq stage. For debugging purposes I made a copy of the job, I removed all parameters and used the browse option to loa...

G:\dev\sdw\Temp\one.txt

I used the browse option to enter this.

Ray, "False" is part of the error message. It is not the file name. Just for fun, I changed the job. All it does is read from a sequential file and write to another sequential file. The job reads the source and writes the target fine -- no errors or warnings. However, I get the previously ...