DSXchange

You don't seem to understand the structure of Data Sets, Ross. The descriptor file (the file whose name ends in ".ds") contains three things: - the record schema for the data - the configuration file that was used when the data were written - pathnames of the "segment files" in w...

Try ignoring Information Server for the moment, and using a dedicated client like SoapUI to get talking to the web service (it doesn't do anything else). This will aid your understanding of what you need to do in DataStage.

It would appear that there are extra columns in Excel that are populated with "" values, and these are being exported when you save as CSV. Try to be a bit more selective with which part of the worksheet you save. Or perform your edits using a tool other than Excel, for example Notepad, Wo...

Have the Oracle credentials changed, and not been updated in this particular project?

To pick up on Craig's post, an IA virtual table cannot perform decryption. You may be able to create a materialized view or similar, however, and profile that.

Welcome aboard. A decrypted copy of the data should be analyzed. While, technically, you could perform column analysis on encrypted data, the results (in terms of values, formats, classifications, and even data types) would be unlikely to be meaningful. And I would warrant that profiling for complia...

Use Oconv() function to convert date to string in server Transformer stage.
Also in the Transformer stage use before-stage and after-stage subroutines to call ExecUV, to execute SET.LOCALE commands so that the stage runs in Spanish locale even though the remainder of the job doesn't.

I have extended the routine so that it handles signed numbers, decimal places, and optional currency prefix of "Rs" or "$". The essentials of the code remain unchanged. FUNCTION LakhFormat(aNumber) If Unassigned(aNumber) Or IsNull(aNumber) Then Ans = @NULL End Else vNumber = aNum...

It was many years ago, but I don't recall any major difficulties of the kind of which you ask.

Set up your Surrogate Key Generator stage to get the next value from the SQL Server sequence.

Use a server job and the Folder stage. If you are required by internal politics only to have parallel jobs, put the Folder stage in a server Shared Container and use that Shared Container in your parallel job. The Folder stage has the capability you are seeking.

Reordering stage variables in a Transformer will not produce a change in the number of Data Sets in the score. Something else has also been changed in the job design, about which you have chosen not to inform us.

Perhaps you could post the two scores?

Get rid of the Final Delimiter property. This asserts that there is an extra delimiter character between the last field and the end of the record, which is not the case in your data.

Welcome aboard. The short answer is yes.

I thought about that for a while, and can't see any technical reason why not. The only problem I could identify would be simultaneous key generation requests from each system leading to failure to have all keys unique, but probably locking on the semaphore would prevent even that. Of course neither ...