DSXchange

With PX jobs you have parallelism which might make jobs more complex (I'm not sure if you mean design-time run run-time complexity); with repartitioning and sorting. The same applies for aggregations and similar actions within the job. Job design spends a lot of time analyzing source data - that al...

Hi , if we list the various parameters which affect the complexity of the job they are as follows: 1) number of rows to be processed 2)complexity of the formulas 3)number of look ups in the job 4)number of source tables and 5) if any additional functionalities like mail notification ,purging of data...