DSXchange

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

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...

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...

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...

Hi Craig, 1) https://i.imgur.com/WoHvhFt.png Where 110 aborts the job, 100 triggers the Job_4. This is the info in the log of Job_3: "Job_3.AfterJob (TD000setJobUserStatus): HDP_CHECK:100". Here, it does not abort nor continue, it just ends. 2) "dsjob -run -warn 200 -jobstatus -param ...

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...

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...

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...

Apparently all those subqueries in the input connector, together with the multiple links to single join stage, were the cause of the problem. After changing the structure a little bit I managed to solved and fully optimize it. Here is the new original job configuration: <a href="https://ibb.co/...

Standard options

All the following are checked:
-Generate order by clause
-Push processing to data sources
-Push processing to data targets
-Push all processing into target data server

Advanced option (among others)

Maximum number of SQL nested joins: unlimited

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...