Search found 31 matches
- Thu Jan 27, 2005 11:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using sorter in parallel
- Replies: 3
- Views: 2102
Using sorter in parallel
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...
- Wed Jan 19, 2005 2:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between Truncate and Delete
- Replies: 6
- Views: 3812
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
- Wed Jan 19, 2005 1:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between Truncate and Delete
- Replies: 6
- Views: 3812
Difference between Truncate and Delete
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
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
- Tue Dec 07, 2004 11:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "Perform sort" option in sorter
- Replies: 1
- Views: 1718
"Perform sort" option in sorter
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...
- Tue Dec 07, 2004 10:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between Dataset stage and Sequential File stage
- Replies: 2
- Views: 14060
- Wed Nov 17, 2004 10:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance using sorter
- Replies: 1
- Views: 1564
Performance using sorter
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 ...
- Wed Nov 17, 2004 9:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reading the records from thesored dataset using transformer
- Replies: 9
- Views: 5416
- Wed Oct 06, 2004 2:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data type convertion in modify stage
- Replies: 7
- Views: 6427
- Thu Sep 30, 2004 12:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data type convertion in modify stage
- Replies: 7
- Views: 6427
data type convertion in modify stage
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"...
- Sun Sep 26, 2004 11:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warining while using hash paritioning
- Replies: 5
- Views: 6158
- Fri Sep 24, 2004 6:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warining while using hash paritioning
- Replies: 5
- Views: 6158
warining while using hash paritioning
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...
- Fri Sep 24, 2004 6:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator Stage
- Replies: 6
- Views: 5142
- Wed Sep 22, 2004 2:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get the distinct count
- Replies: 6
- Views: 4057
- Tue Sep 21, 2004 10:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: restartability in db2 enterprise stage
- Replies: 5
- Views: 3132
- Tue Sep 21, 2004 10:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get the distinct count
- Replies: 6
- Views: 4057
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...