Cmdlets for Workday

Build 22.0.8479

UseSplitTables Parameter (Connect-Workday Cmdlet)

Whether to split WQL data sources into multiple tables.

Syntax

Connect-Workday -UseSplitTables SwitchParameter

Data Type

bool

Default Value

false

Remarks

Workday data sources will often have several hundred fields, with some data sources like allWorkers having thousands of fields. Many database and reporting tools do not support tables with this many columns. By default the 本製品 exposes the data sources the same way Workday does, so tools with these limitations cannot use larger data sources.

Enabling this option allows the 本製品 to be used with these tools. When split tables are enabled, the 本製品 creates multiple tables for complex Workday data sources. Each split table contains between 50-100 columns, along with the primary key, last modified timestamp and effective and entry inputs.

JOINs can be used if data is required from columns that are part of different split tables.

SELECT a.academicDegree, b.yearsExperience
FROM allWorkers_1 a INNER JOIN allWorkers_60 b
ON a.workdayID = b.workdayID

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479