Sql Server 2008: Data Mining Project in BIDS: Why cant data source views be based on a query?
I've created an analysis services project in BIDS with the intention of creating a mining strucuture. I notice that you cannot create a data source view based on a query and that it must be based on linking actual tables (via the access looking GUI). In my scenario I have a very long and complicated query which uses temp tables to retreive the data I want to use for mining. Am I forced to insert this data into a table in order to create and use a mining structure? Or are there other ways to do it?
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.