I often have a table with a large number of zero values ( rather than null values) in soem columns that I then need to Unpivot. This results in a table with a large number of rows where the valu column is zero and this impacts overall performance.
There is already an option on the Unpivot Transformation to Ignore Null Values - it would be great if there could also be an Ignore Zeros option