DFT Load FactStudentTotalFees

Property	Value
Name	DFT Load FactStudentTotalFees
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

Name	Type	Description
Check for SK Nulls	12	Updates column values using expressions
Lookup PaymentSourceSK	12	Looks up values in a reference dataset by using exact matching.
Lookup StudentSK	12	Looks up values in a reference dataset by using exact matching.
LookupStudentTermSK	12	Looks up values in a reference dataset by using exact matching.
LookupTermSK	12	Looks up values in a reference dataset by using exact matching.
OLE DB Load into FactStudentTotalFees	10	OLE DB Destination
OLE_SRC FactStudentTotalFees_Staging from Operations	9	OLE DB Source

Component	Input Column	Destination Column
Check for SK Nulls
Derived Column Input
	PaymentSourceSK [?]	PaymentSourceSK
	StudentSK [?]	StudentSK
	StudentTermSK [?]	StudentTermSK
	TermSK [?]	TermSK
Lookup PaymentSourceSK
Lookup Input
	PaymentSourceAK [?]	PaymentSourceAK
Lookup StudentSK
Lookup Input
	StudentIdAK [?]	StudentIdAK
LookupStudentTermSK
Lookup Input
	StudentTermAK [?]	StudentTermAK
LookupTermSK
Lookup Input
	TermAK [?]	TermAK
OLE DB Load into FactStudentTotalFees
OLE DB Destination Input
	PaymentSourceSK [?]	PaymentSourceSK
	StudentSK [?]	StudentSK
	StudentTermSK [?]	StudentTermSK
	TermSK [?]	TermSK
	TotalFeesAssessed [?]	TotalFeesAssessed
	TotalFeesExempted [?]	TotalFeesExempted
	TotalFeesNotPaid [?]	TotalFeesNotPaid
	TotalFeesPaid [?]	TotalFeesPaid

Name

Value

Description