Merge-Partition
此 cmdlet 将一个或多个源分区的数据合并到一个目标分区中,然后删除源分区。
语法
Merge-Partition
[-Name] <String>
-SourcePartitions <String[]>
-Database <String>
-Cube <String>
-MeasureGroup <String>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Merge-Partition
-SourcePartitions <String[]>
-Database <String>
-Cube <String>
-MeasureGroup <String>
-TargetPartition <Partition>
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Merge-Partition
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Merge-Partition
[-Server <String>]
[-Credential <PSCredential>]
[-ServicePrincipal]
[-ApplicationId <String>]
[-TenantId <String>]
[-CertificateThumbprint <String>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
说明
此 cmdlet 将一个或多个源分区的数据合并到一个目标分区中,然后删除源分区。
只有符合下列所有条件的分区才能合并:
- 这些分区位于同一度量值组中。
- 这些分区都以相同的模式(MOLAP、HOLAP 和 ROLAP)存储。
Module requirements: version 21+ on PowerShell 5.1; version 21 (recent preview) or version 22+ on PowerShell 7.x.
示例
合并分区
$sources = "customers_2006","customers_2007","customers_2008"
PS C:\> Merge-Partition -Name:Customers_2005 -SourcePartitions:$sources -Database:"AdventureWorksDW" -Cube:"Adventure Works" -MeasureGroup:"Internet Customers"
参数
-ApplicationId
服务主体的应用程序 ID。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-CertificateThumbprint
服务主体的证书指纹。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
提示你在运行 cmdlet 之前进行确认。
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Credential
如果指定此参数,将使用传递的用户名和密码连接到指定的 Analysis Server 实例。 如果未指定凭据,将使用正在运行该工具的用户的默认 Windows 帐户。
Type: | PSCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Cube
其中存在这些分区的多维数据集的名称。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Database
其中存在这些分区的分析服务器数据库的名称。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-MeasureGroup
其中存在这些分区的度量值组的名称。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
应在其中合并源分区数据的目标分区的名称。
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Server
(可选)指定要连接到的服务器实例(如果当前不在 SQLAS 提供程序目录中)。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServicePrincipal
指定此连接使用服务主体。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SourcePartitions
其中的数据合并到目标分区的源分区名称。
Type: | String[] |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetPartition
指定源分区数据将合并到其中的目标分区。
Type: | Partition |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-TenantId
服务主体的租户 ID。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
显示在此 cmdlet 运行的情况下将会发生什么。 此 cmdlet 未运行。
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
输入
Microsoft.AnalysisServices.Partition
备注
在兼容级别为 1200 或更高版本的表格数据库上不受支持。