DimRelativeDayLoad
 DFT Load Temp Staged Term from Staging (Data Flow Task)
  DataFlow Screenshot
  Properties
Property Value
Name DFT Load Temp Staged Term from Staging
Description Data Flow Task
Precedence Executables none
Contrained Executables none
ID 96fa5107-c304-41eb-b4be-b3aaedab7dd3
BLOB Temp Storage Path
Buffer Temp Storage Path
Default Buffer Max Rows 10000
Default Buffer Size 10485760
Run In Optimized Mode True
Locale ID English (United States)
Logging Mode UseParentSetting
Forced Execution Value 0
Force Execution Value False
Delay Validation False
Disable False
Disable Event Handlers False
Fail Package On Failure False
Fail Parent On Failure False
Maximum Error Count 1
Isolation Level Serializable
Suspend Required False
Transaction Option Supported
  Components
Name Type Description
10
OLE DB Destination
9
OLE DB Source
12
The case transformation corrects, cases and standardizes names, addresses or any text to proper case for any input columns data.
  Column Mappings
Component Input Column   Destination Column
OLE_DST Insert into Staged_dbo_DimRealtiveDay
   OLE DB Destination Input
 
SRCRelativeDay [?]
RelativeDay
 
SRCRelativeDayDate [?]
RelativeDayDate
 
SRCRelativeDayDateSK [?]
RelativeDayDateSK
 
SRCRelativeDayNumber [?]
RelativeDayNumber
 
SRCRelativeDaySK [?]
RelativeDaySK
 
SRCTerm [?]
Term
 
SRCTermTitle [?]
TermTitle
 
SRCTermTypeCode [?]
TermTypeCode
 
SRCTermYear [?]
TermYear
TF Case Transform
   Name Parse Input
 
SRCRelativeDay [?]
SRCRelativeDay
 
SRCRelativeDayDate [?]
SRCRelativeDayDate
 
SRCRelativeDayDateSK [?]
SRCRelativeDayDateSK
 
SRCRelativeDayNumber [?]
SRCRelativeDayNumber
 
SRCRelativeDaySK [?]
SRCRelativeDaySK
 
SRCTerm [?]
SRCTerm
 
SRCTermTitle [?]
SRCTermTitle
 
SRCTermTypeCode [?]
SRCTermTypeCode
 
SRCTermYear [?]
SRCTermYear
  Variables
Name Value Description
Powered by BI Documenter