Hi mouthou, thank for your suggestion. I did not consider this solution because I'm not very familiar with that, but I will defintely will in the future, when time will be on my side.
Thanks
Search found 11 matches
- Thu May 23, 2019 2:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Balance Optimization fails
- Replies: 5
- Views: 4120
- Wed May 22, 2019 9:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Balance Optimization fails
- Replies: 5
- Views: 4120
Balance Optimization fails to create query
Thanks chulett, my mistake. After developing many prototypes, some of which actually failed to create a correct query, I assumed that the repetition was an error, while it is just the alias. I got confused. (plus, recently there was a problem with the optimization that was verified by our vendor, so...
- Wed May 22, 2019 8:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Balance Optimization fails
- Replies: 5
- Views: 4120
Balance Optimization fails to create query
Apparently I had not yet tried the most obvious solution, which was to insert a sort stage bewtween the teradata connector and the remove duplicate stage. This is a step forward. but now have another problem. The query that is built, is wrong. The syntax is wrong. Considering that 1) this is an atte...
- Sun May 19, 2019 8:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Balance Optimization fails
- Replies: 5
- Views: 4120
Balance Optimization fails
Hello, I have a job datastage that cannot be optimized: in other words the optimized is equal to the original. In the Optimization logs I find 2 warnings that I'm translating from Italian, that state: WARNING: It is not possible to verify the sorting keys in the stage Read_table_1. The pattern is ab...
- Tue Apr 02, 2019 12:40 am
- Forum: General
- Topic: Sequence skips job execution
- Replies: 4
- Views: 3124
- Mon Apr 01, 2019 9:04 pm
- Forum: General
- Topic: Sequence skips job execution
- Replies: 4
- Views: 3124
Sequence skips job execution
Hello, I have a situation I do not fully understand. A sequence scheduled and run by TWS skips the executon of the last job. This is the summary of the sequence run when scheduled by TWS: SEQUENCE..JobControl (@Coordinator): Summary of sequence run 23:50:24: Sequence started (checkpointing on) 23:50...
- Sun Jan 27, 2019 10:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal to String keeping 2 decimal places digits
- Replies: 3
- Views: 4687
Hi Craig, thanks for your suggestion (and apologies for late reply). Unfortunately I could not do as suggested. I managed it this way: 1) rounded to 2 decimal places in the select statement using the following formula: TRIM(CAST(my_field as DECIMAL(32,2) FORMAT 'ZZZZZZZZZZZZZZZZ9.99')) as my_field_c...
- Fri Dec 14, 2018 1:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal to String keeping 2 decimal places digits
- Replies: 3
- Views: 4687
Decimal to String keeping 2 decimal places digits
Good day, my goal is to convert a decimal(32,15) into a CHAR(20) and writes it in a fixed length sequential file. The relatively simple job reads data from a teradata table, sends data to a transformer, writes result to text file. Here follows a view of the job: https://imgur.com/PhN0UUE Example dec...
- Wed Jul 25, 2018 4:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job with multiple joined tables not fully optimized
- Replies: 4
- Views: 2670
- Thu Jul 19, 2018 2:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job with multiple joined tables not fully optimized
- Replies: 4
- Views: 2670
- Wed Jul 18, 2018 8:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job with multiple joined tables not fully optimized
- Replies: 4
- Views: 2670
Parallel job with multiple joined tables not fully optimized
Hello, I am trying to optimize a parallel job that contains 7 teradata connector as input, 1 teradata connector as output. In between a join stage (and a few transfomer stages) that put all input tables together. see a picture: http://i67.tinypic.com/121xy7p.png The result is a non fully optimized j...