In the last months I and Alberto Ferrari worked on many consulting engagements about designing Tabular models or optimizing existing ones. One of the strength of the Tabular model compared to Multidimensional is the performance of distinct count measures.
Almost one month ago I made a post about a brand new Distinct component for SSIS made by Alberto Ferrari and freely available on SQLBI.EU . The most used way to get distinct rows in a Data Flow that I’ve seen is to use the Sort component, asking only
Alberto Ferrari has published on SQLBI.EU a Distinct component for SSIS . The big advantage is less memory used when you have few distinct values extracted from a large set of data. Component and source code are freeware. Now the challenge is: how to