DSXchange

Okay thanks i got it...! using stage variables i can handle and define the ranks.

Why not? we will be doing rank based on a certain column value.
why cant we have one stage which takes this column values in cache sort it and assign ranks and release in the data streams,
I Apologize if have said anything wrong technically and please correct me if i have said anything wrong.

Yes i got it Ray, But what is there is a requirement for me to populate one of the columns in the table with Ranks?
Bcos i see here we have many many stages which are doing similar operations. why didnt IBm make one stage for ranking.

Thanks andrew, but did we get any solution for this assuming we dont have more cpu's to add.

Thanks andrew, but did we get any solution for this assuming we dont have more cpu's to add.

Hi There,
Can anyone please tell me is there any Rank function available in datastage.
or is there any way to achieve this?

thanks

Are you able to write few data?
or try to create a empty file and try to overwrite the file...!

You can do this by defining stage variables which will look for the change in the first column and one stage variables which will value as you have mentioned.

Oh okay...thanks for the information.
in that case it wont be useful for me when restarting the job from the point of failure.

Did this really work?

"constraint in a transformer (@INROWNUM > X)"" if YES then its really good one....!

Cant you do this in a transformer?

Where you are using a Copy stage with a single input and a single output, you should ensure that you set the Force property in the stage editor TRUE. This prevents WebSphere DataStage from deciding that the Copy operation is superfluous and optimizing it out of the job.

In the Admin clients, you have ADD, REMOVE etc tabs below that you have NLS tab there you can set the value.

Try to load it into Dataset it would be much faster and Null handling will be taken care much easily here.

For Temp Table Use Full Refresh, Write a small script to truncate the temp tables, and run the full refresh job, configure all this in a sequence.

For Upsert user Upsert Mode in oracle EE stage target.

i think it should be very simple jobs.

Please let me know if you need further information.