Direct Load Business Rules

Special Workflow Rule BRAPI Functions

The Direct Load Workflow includes supporting BRAPI’s to aid in programmatical Business Rule development.

Determine Workflow Types

Boolean to determine the Workflow Type

  • BI Blend - BRApi.Workflow.General.IsBiBlendWorkflow(si, wfClusterPk)

  • Direct Workflow - BRApi.Workflow.General.IsDirectLoadWorkflow(si, wfClusterPk)

Information Tables

Retrieve details from BI Blend’s StageBIBlendInformation and Direct Load’s StageDirectLoadInformation tables

  • As StageBiBlendInfo = BRApi.Import.Data.GetBiBlendInfo(si, wfClusterPk)

  • As StageDirectLoadInfo = BRApi.Import.Data.GetDirectLoadInfo(si, wfClusterPk)

Error Management

Details for Transformation and Intersection errors relative to the current Direct Workflow process. Direct Load’s in-memory processing only supports 1000 errors per load/import.

  • As DataTable = BRApi.Import.Data.GetDirectLoadTansformationErrors(si, wfClusterPk)

  • As DataTable = BRApi.Import.Data.GetDirectLoadIntersectionErrors(si, wfClusterPk)

Summarized Target Data

The Direct Load Workflow has two settings to manage summarizing Stage records as Row or Blob. The Blog method does not physically write records to the StageSummaryTarget Table. These BRAPI’s are built to automatically determine the storage method and retrieve the records.

  • As DataTable = BRApi.Import.Data.ReadSummaryTargetDataTable(si, wfClusterPk)

  • As DataTable = BRApi.Import.Data.ReadSummaryTargetDataTableTimeRange(si, wfClusterPk, cubeStartTimeId, cubeEndTimeId)