DSXchange

ArndW wrote:Are you the original poster for that topic? ...

Yes, I am the original poster of this topic. Thats obvious. I wont try marking those topics resolved which are posted by others.


I have been facing this problem for a little while now.

This post is related to DSXchange website. I am not able to mark a topic resolved. When I try to do so, I get a failure dialog box

Thanks Aneesh!!!!! For the replies you gave to each of my questions, that solves all my doubts connected to sort stage.

I am not clear on this. I have few questions: 1) If I use an ORDER BY clause in DB2 stage, the output data is sorted. This sorted data is passed to join stage. Do you mean to say that in the join stage, tsort operators will again try to sort the already sorted data of the DB2 stage? 2) Suppose I use...

Nagesh, do you mean to say that, if I include explicit sort stage, then DataStage won't use tsort operators?

It does not make sense to me to use sort stage and then again tell the stage "Dont' sort".

Join Stage basically needs the input to be sorted. This is achieved by ORDER BY clause in DB2 stage itself. Even after specifying ORDER BY in DB2, is there a necessity to include an explicit sort stage, and then again specify "don't sort " in that stage. Is there a point in doing this beca...

I am joining two DB2 tables. Is it necessary to put an explicit Sort Stage before join or can I use the ORDER BY clause in the DB2 query itself and then directly link the DB2 stages with the Join stage without using Sort?

Thanks. It was a mistake on my part to search for this one in PX forum. Now I have got the material in server forum

Thanks!! ArndW. I searched and got the solution. Earlier, I did not select the "Search All Terms" option. That was the reason for not getting the results.

Did not find any. Could you please help?

I know its obvious to get the warining "When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0". when a sequential file is connected to a transformer in a parallel extender and while the transformer is propagating the partiti...

The problem has been resolved now. It was very simple. I wanted to carry forward the sum of the values of the field AMT from DB2 stage to a flat file. The metadata for AMT was decimal (9,2) and non nullable in the original table. But I came to know that when we perform a sum function in PX it always...

I dont have access to premium content. What is the syntax for handling null values in modify stage. I want to convert null to non null

My problem is un resolved as of yet. Can anyone tell me the syntax of the function for converting nullable to non nullable? I wil use this in the modify stage. I am trying to use NullToValue function on the field AMT. I want the modify stage to convert any null value coming out of the previous stage...

I am afraid but I can't view the Premium Content. Anyway, we are getting off the track here. Where does this dfloat come from? I have used Aggregator in my job and have been able to see off one warning(Refer my first post in this thread. The first warning is not appearing now after using Aggregator)...