FactStudentReceiptPaymentsLoad
 DFT Load FactStudentReceiptPayments (Data Flow Task)
  DataFlow Screenshot
  Properties
Property Value
Name DFT Load FactStudentReceiptPayments
Description Data Flow Task
Precedence Executables none
Contrained Executables none
ID c6b342c8-4bdf-4503-8e35-4da2f38da736
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
12
Updates column values using expressions
12
Looks up values in a reference dataset by using exact matching.
12
Looks up values in a reference dataset by using exact matching.
12
Looks up values in a reference dataset by using exact matching.
12
Looks up values in a reference dataset by using exact matching.
10
OLE DB Destination
9
OLE DB Source
  Column Mappings
Component Input Column   Destination Column
Check for SK Nulls
   Derived Column Input
 
DateSK [?]
DateSK
 
ReceiptPaymentCategorySK [?]
ReceiptPaymentCategorySK
 
StudentReceiptSK [?]
StudentReceiptSK
 
StudentSK [?]
StudentSK
Lookup ReceiptPaymentCategorySK
   Lookup Input
 
ReceiptPaymentCategory [?]
ReceiptPaymentCategory
Lookup StudentReceiptSK
   Lookup Input
 
StudentReceiptAK [?]
StudentReceiptAK
Lookup StudentSK
   Lookup Input
 
StudentIdAK [?]
StudentIdAK
LookupDateSK
   Lookup Input
 
DateAK [?]
DateAK
OLE DB Load into FactStudentReceiptPayments
   OLE DB Destination Input
 
DateSK [?]
DateSK
 
ReceiptPaymentAmount [?]
ReceiptPaymentAmount
 
ReceiptPaymentCategorySK [?]
ReceiptPaymentCategorySK
 
StudentReceiptSK [?]
StudentReceiptSK
 
StudentSK [?]
StudentSK
  Variables
Name Value Description
Powered by BI Documenter