DFT Load FactStudentSuccess_FirstYearSnapshot Table

Property	Value
Name	DFT Load FactStudentSuccess_FirstYearSnapshot Table
Description	Data Flow Task
Precedence Executables	none
Contrained Executables	none
ID	b2fcb184-1c2d-4210-94c4-01a4c56e2338
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
Conditional Split	12	Evaluates and directs rows in a dataset.
Lookup Cohort Term	12	Looks up values in a reference dataset by using exact matching.
Lookup First Year Term	12	Looks up values in a reference dataset by using exact matching.
Lookup Student	12	Looks up values in a reference dataset by using exact matching.
Lookup Student Cohort	12	Looks up values in a reference dataset by using exact matching.
Lookup StudentObjective	12	Looks up values in a reference dataset by using exact matching.
Merge Join	12	Merges data from two datasets by using a join.
OLE DB FactStudentSuccess_FirstYearSnapshot	10	OLE DB Destination
OLE_SRC Cohort Term Data	9	OLE DB Source
OLE_SRC Student Success First Year Snapshot from Staged Table	9	OLE DB Source

Component	Input Column	Destination Column
Check for SK Nulls
Derived Column Input
	FirstYearTermSK [?]	FirstYearTermSK
	StudentObjectiveSK [?]	StudentObjectiveSK
	StudentSK [?]	StudentSK
	StudentSuccessCohortSK [?]	StudentSuccessCohortSK
	StudentSuccessCohortTermSK [?]	StudentSuccessCohortTermSK
Conditional Split
Conditional Split Input
	DimFirstYearTerm [?]	DimFirstYearTerm
	FirstYearTerm [?]	FirstYearTerm
Lookup Cohort Term
Lookup Input
	CohortTerm [?]	CohortTerm
Lookup First Year Term
Lookup Input
	FirstYearTerm [?]	FirstYearTerm
Lookup Student
Lookup Input
	StudentId [?]	StudentId
Lookup Student Cohort
Lookup Input
	CohortTerm [?]	CohortTerm
	StudentId [?]	StudentId
Lookup StudentObjective
Lookup Input
	StudentObjectiveAK [?]	StudentObjectiveAK
Merge Join
Merge Join Left Input
	AttendedSummerTerm [?]	AttendedSummerTerm
	CompletedCollegeExpCourse [?]	CompletedCollegeExpCourse
	CompletedGatewayCourse [?]	CompletedGatewayCourse
	DidNotMeetAny1stYearSuccessFactors [?]	DidNotMeetAny1stYearSuccessFactors
	FirstYearTerm [?]	FirstYearTerm
	Meets24CreditsRequirement [?]	Meets24CreditsRequirement
	Meets67PctCompletedRequirement [?]	Meets67PctCompletedRequirement
	MeetsGPARequirement [?]	MeetsGPARequirement
	StudentId [?]	StudentId
	StudentObjectiveAK [?]	StudentObjectiveAK
Merge Join Right Input
	CohortTerm [?]	CohortTerm
	DimFirstYearTerm [?]	DimFirstYearTerm
	StudentId [?]	StudentId
OLE DB FactStudentSuccess_FirstYearSnapshot
OLE DB Destination Input
	AttendedSummerTerm [?]	AttendedSummerTerm
	CompletedCollegeExpCourse [?]	CompletedCollegeExpCourse
	CompletedGatewayCourse [?]	CompletedGatewayCourse
	DidNotMeetAny1stYearSuccessFactors [?]	DidNotMeetAny1stYearSuccessFactors
	FirstYearTermSK [?]	FirstYearTermSK
	Meets24CreditsRequirement [?]	Meets24CreditsRequirement
	Meets67PctCompletedRequirement [?]	Meets67PctCompletedRequirement
	MeetsGPARequirement [?]	MeetsGPARequirement
	StudentObjectiveSK [?]	StudentObjectiveSK
	StudentSK [?]	StudentSK
	StudentSuccessCohortSK [?]	StudentSuccessCohortSK
	StudentSuccessCohortTermSK [?]	StudentSuccessCohortTermSK

Name

Value

Description