DSXchange

I doubt that they'll do this, since the philosophy in parallel jobs is "one stage, one task". Certainly there are no plans to include lookup capability in the Transformer stage. But, hey, if you don't ask it will definitely never happen. Hi Ray, Thanks for your reply. I think, we have to ...

Nagesh, If there are any decimal type columns, then we can add an environmental variable 'APT_DECIMAL_INTERM_PRECISION' and set the value to 2. by default it is 38. by this we are limiting the internal calculations to use only 2 precision, which might speed up the job. PerterPol, It is enough to do...

Hi Elavenil,

After all these posts and from my experiecnce, it is always better to choose UNIX environment rather than Windows. It will be very helpful in the sense of security and maintaince.

It doesn't seem to help (still 48 minutes), or may be I misunderstood your advise... I added a sort stage before the aggregator stage to sort input on the aggregator grouping key. In both the sort and aggregator stage I selected hash partitioning. Peter Hi Peter, Its not required to perform HASH pa...

tejaswini wrote:among the columns which you are aggregating, are there any decimal columns?

Hi tejaswini,

May I know, how it make difference with the performance if we have the decimal fields in the aggregation key. Can you explain the same, please.

Hi, I have posted this question already in Parallel enterprise edition forum about Lookup stage in parallel 7.5.1. In the present 7.5.1 lookup stage GUI, in lookup it's allowing to trim the columns and passing the parametsr as a lookup key and some other Transformer stage compatable functions. But, ...

Hi,

Better to search in this forum, where you will get 'N' number of posts related to this topic 'Preserve Partitioning'.

hi, In job already I am having a separate 'SORT' stage. Also I am sorting explicitly on the same keys on which I am partitioning in the same stage. Now should I check the perform sort option also for the sort to happen? In this scenario, checking and unchecking this option mean the same or differen...

Hi,

Adding few more points to the Arnd solution, perofrm HASH partition in the Sort stage before aggregator stage on grouping keys that you are using in the Aggregator stage. Your data will sort properly based on group keys and your job performance will increase.

Hi,

I think in your case, you can use UR ( Uncomitted Read or dirty read) in the SQL query itself by using WITH UR at the end. Usually we are doing the same thing in DB2 stage.

Hi, The following description given in Parallel Job Developers Guide , Perform Sort : Select this to specify that data coming in on the link should be sorted. Select the column or columns to sort on from the Available list. Usually, it is very helpful, if you want to perform link sorting, that means...

My 2 cents : Parallel job functions arent as well documented the way server job functions are. No examples of using functions and results have been documented. So some amount of trial/error is a must. In the orchestrate reference manual, we can find the functions with proper syntax and examples for...

how to sort data inside teradata when it is a source and i have only the output tab where no partitioning tab is available, when it is in target we can see the input tab and partitioning tab where we can perform a sort.kindly do reply.. You will have to give a suitable Order By clause in the SQL qu...

It works but we need to eliminate these kind of warnings. "Jn_Tgt_Lkp_Ins: When checking operator: On input data set 1: When binding input interface field "ABU_KEY" to field "ABU_KEY": Implicit conversion from source type "int64" to result type "decimal[10,0]...

Hi, I think problem with the library files and its not loaded properly in your system. Check the $LIBPATH environment variable, to identify lib path of your project.

Regards,
Nagesh.