October 27, 2016 at 12:54 pm
Hi, still somewhat a SQL Server Stack newbie, I'm taking over an new/existing SQL Server 2012, SSIS and SSAS system, and the designer is VS 2013 and Data Tools.
The developer/designer built several SSIS and SSAS packages, and has a number of daily, weekly, and monthly cubes running in place. All of these cubes use the Tabular Partition Table arrangement. There are no cubes created yet that do not use the partition tables to control partition data processing.
If I create a new cube, and want to use the partition tables, what tables do I update with what values to take advantage of the existing partitions? I know the easy way, is copy an existing project that is closet to the new one, and that way the metadata and partition data comes with it. So even if I did that, surely I have new records to insert into the partition tables to ultimately get the new cube operations with the partition tables, and all the SPROCS that interface between the cube, tables and partitions.
Thanks,
JPQ
October 28, 2016 at 7:55 am
Does anyone use the Tabular Model Partitions in SQL 2014? In favor of them?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply