Hey,
Do we have any component or any way to calculate weighted Average in Talend?
I am using tAggregate to compute sum, average and count. But i didn't find any function to compute Weighted Average.
I know we can do it in tMap by writing the expression but is their any easier way?
Thanks!
We could definitely turn this Job as ELT/SQL Pushdown mode to scale if your data become huge.
Beside the Aggregate and Sort operations; the rest of the other operations will work just fine in the Design I did and you won't benefit any better performance if you want to take advantage of your Column level processing approach.
You alternative are :
#1 you bulk load your Input file in a RDBMS database and you perform your operation using our ELTMap capabilities.
#2 you adopt a best of breed approach; you load in Databse; the result of the first tMap1; then you perform the Aggregate and Sort in database using the ELT approach; and then you read/extract the Table perform the tMap2 operation in order to produce back your output file expected.
Best regards;
