August 25, 2016 at 9:48 am
Currently I have a Mining Structure with 5 Models. All 5 models are normalized in the sense their columns match up. For each model I have two queries one that predicts the forecast and one that shows the CASES (The data fed into the mining models.
My questions is in your opinion what would be the best way to take the data from these queries and put them into a singular table in SSMS?
I gotta believe it's SSIS with the Analysis Services Process and the transformation data flow (data mining query)
I'm just hitting a little writers block on taking the output from the data mining query and passing it to a table structure I have built.
THoughts on creating 10 seperate data mining queries and passing them through a union all to the source table?
Thanks again.....
Querying Microsoft SQL Server 2012/2014 - Certified
August 25, 2016 at 10:40 am
I've been doing some research, maybe I need to go back to 101. My biggest road block is not being able to map from the data mining query to union all. Since it's going to a SQL Server I was able to map from the output side, but no dice with the input from DMX.
Think maybe script task might work? ......
Querying Microsoft SQL Server 2012/2014 - Certified
August 25, 2016 at 11:41 am
Two words. Extended Properties. Change to Tab and you are set.
Querying Microsoft SQL Server 2012/2014 - Certified
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply