i have a requirement of finding sum of salaries for all the active employees,
i'm finding it difficult with aggregator stage as it needs group by column where i do not need to group by, is there any other stage which supports me to get the required output.
Or If you don't have any such column and consider all rows in the table as active employees then you can just create one more temp column with any default value and the you can use it as your grouping column.
I have created a static variable with a constant value in transformer and in aggregator ive grouped by that variable, now im getting the desired output but my question in performance perspective is this the best way?
I don't have any way to check directly but it should be a 'Generate' option and the need to set it to something other than 'Cycle'... I think. Poke around and see if you can set it to generate a constant value... or perhaps cycle a number by 0?
And there's no "performance" problem with solving this using a transformer.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Click on the Output->Columns, then right-click on the generated column select Edit Row...
Generator->Algorithm
Choose your type. The algorithm types available vary depending on data type. For char/varchar and this job, I would choose Cycle and give it only one value to cycle through. The other type is Alphabet and you provide a string of characters for it to cycle through (again, for this job just enter one character). Other data types should be self-explanatory.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.