Avanced ETL Processor Pivot Table vs SQL Pivot Table

This is running against a very large SQL table. However, you can see the SQL version of the pivot table is much faster. Over an hour vs 30 seconds.








Just thought I would share.

Just to clarify, I do updates and inserts:

Thank you for the feedback

We will have a look at it.

Hi Dean

We have made some minor tweaks to Pivot and UnPivot objects and we hope that it works a little bit faster now.

Full list of chages

+ Added: GetWindowsTemporaryDirectory,GetTemporaryFile,GetTemporaryFileInDirectory,GetTemporaryDirectory transformation language functions
+ Added: Get File Content Dynamic transformation function
+ Improved: Third party components update
+ Improved: Pivot and unpivot performance

I will definitely have to check into it. I checked this morning. For some reason, it's back to take an hour again.

I was able to get my time back. Found out. the mappings have all disappeared. Added all the mappings back and life was good again.