I have created a package that has SQL Server & Sybase datasources. Without joining them together in report studio, if I look at the SQL generated one from SQL Server and other from Sybase,
I dont see the 'Distinct' clause being applied in the SQL Server (only dimensions with no facts).However, Sybase query has the Distinct function in the SQL.
I was expecting to see 'Distinct' clause for both the queries. Please let me know if I'm missing something in the Framework Manager that enforces Distinct clause.
Please note that I'm dragging dimension information only, not using any fact columns in the query and Auto Summarized is set to 'YES'
Appreciate your inputs on this.
Regards
Raj