DSXchange

This is what you want/need. The IBM WebSphere DataStage SOA Edition upgrade allows IBM WebSphere DataStage functions to be easily deployed as services, without requiring changes to the core logic of the overall job. These services are developed using a simple and intuitive wizard that creates all ne...

Morning all, Has anyone had success on doing a COPY_A on a substring in a token? Looking at the pattern matching documentation it says that I should be able to do a COPY_A on a substring. (Doesn't given an example tho :roll: ) If I try the code below for testing purposes I don't get a result in the ...

Is there any error given when you try to reinstall the profilestage client?

Tim

Ketfos, In the Basic documentation it says TRIM( expression, [,Character [,option]). Your trim is Trim(string, "D"). Trim must be thinking that "D" is the character rather than the option. Because it is thinking that the "D" is the character and no option then the rule ...

Ram,

This topic has been discussed many times on this forum. Use the search function to find them.

Here is a link I found with a great explanation by Ray Wurlod.

viewtopic.php?t=94033&highlight=hash+file+types

Cheers

Tim

Sravan, I don't think there is a set limit to the number of hashed files that you can have in a single job. The amount of hash files that you can have in your job will be limited by other factors. Such as the amount of RAM on the server. The design of your jobs. (I would be looking at you job design...

Hi Sravan,

Yes you can use hash files as a source as well as hash files as a target.

Or did you want to know if you could use them at the same time?

Tim

Sorry my mistake. Didn't have a copy of Datastage to double check if the pivot stage did both pivots.

The pivot stage should provide you with what you want.
Don't know if you need to install it as a plugin or not.

You should be able to read more information about the pivot stage in the plugin documentation. Should be in the docs folder in the datastage client folder on your pc.

You can also move the column orders around in a transform stage. Clicking on a field in the grid at the bottom of the transform window and dragging it above or below the other fields should move it.

There is a basic pdf file that comes with Datastage. Look at the built in routines and the SDK routines that come with datastage as a guide.

Yes it will be.

Are you sure that both the records are the same as the previous records at the same time in your data?

Your code should work based on the output of the Rowcompare routine.

I assume that if the previous IDs aren't there then the Stage variable is null.

What is the derivation for the stage variables?

2) Enterprise Edition to handle the volume. Consider materialised database views for your end users so that when your marts are being reloaded their queries can still access the old data. Do delta loads and not full loads so your twice daily loads are small in volume. Put your data marts on another...

On a project I was working on we were having mutex errors while using link collectors. They were running datastage 7.5.1 on a AIX server. Seems that there was a glitch in he AIX operating system which was causing the mutex error on any jobs using a link collecter. Anyone here that is having mutex er...