DSXchange

Hi I want to know the better option of using the sorter. 1) To have all the rows flowing in a same sorter 2) To have several sorters in the same places by spliting the rows and sort the same. Is there any impact of memory allocation while using 2 sorters in the place of 1. Can any one suggest for th...

Hi Thanks for your great interest. In DB2/UDBEnterprise stage as of my knowledge both the truncate and delete option send the commond as Delete, if so how does Truncate option will be more faster than the delete option. How does it internally works on. Can you put some more light on the same. Thanks

Hi

What is the difference between the DELETE mode and WRITE - TRUNCATE mode. What will be the impact of the same in database.

Can any one help me out on the same.

Thanks in advance

Hi I am using an aggregator with sort option in it. Before which a sorter stage has been used. The sorting has been performed on the keys used in the aggregator. The partioning used in the sort is hash partion based on the same keys and in the aggregator the partiotioning is "same". My que...

Data set can be partioned as of the required number of nodes and thus it can be run in parallel. You can defines as many number of nodes as you can.

But incase of sequential file, it extracts and writes through sequential.

Hi In my job i am using db2 and a sorter stage followed by a aggregator. In this my sorter stage is taking 3/4th time of the overall run. I tired to increase the memory usage from the default to 20MB to 300MB. Even then the time is not that much reduced. What can be done to increase the performance ...

You can use the stage variables effectively in this. Counter logic can be incorparated in stage variables and this can be used as a constraint which might give you a better solution.

Hi

Thanks for your suggestions, now its work fine.
I changed the input length from 10 to 9 so that it converts decimal(9,0) to integer

Thank U

hi I want to convert a column from the datatype decimal(10,0) to integer without any warnings using a modify stage. I tired to use the function "int32_from_decimal" but its returing rows with warning. When checking operator: When binding output schema variable "APT_TRoutput0Rec0"...

Thabnks for the response actually for my previous query it got solved by the similar kind of warning i am getting over again and again in diiferent form buffer(7): When checking operator: Operator of type "APT_BufferOperator": Will partition despite preserve-partitioning flag on dataset on...

While i am using a hash partioning either in join or a sort following a join has the following warning [img]When%20checking%20operator:%20Operator%20of%20type%20"APT_TSortOperator":%20Will%20partition%20despite%20preserve-partitioning%20flag%20on%20dataset%20on%20input%20port%200[/img] Thi...

In aggregator stage the default output data type is dfloat, you can convert the datatype to decimal by adding the "Available sub prodperity to add" has the "Decimal Output" option

Just check with that one, which will solve your first query as i suppose

I want to take a distinct of combination of two columns transaction_date(date) and transaction_sequence_id(integer)

I am using write mode. Thanks of ur great response, i hope this would be help full for me. Could you please through some more light on what will be the maximum commit level that we can give to a DB2

I tired this with too different aggregators thats working fine, whether i can acheive this in a single aggregator. I tired it with converting the input column to double and having the same coulmn in both group by and count column too. It worked but output i got is not what is expected for distinct c...