DFT Load FactHoursByWeek Reporting into EDW

Property	Value
Name	DFT Load FactHoursByWeek Reporting into EDW
Description	Data Flow Task
Precedence Executables	none
Contrained Executables	none
ID	b2c6c2b2-9708-4d9c-af16-5d8d20253574
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 EmployeeSK	12	Looks up values in a reference dataset by using exact matching.
Lookup TimeTypeSK	12	Looks up values in a reference dataset by using exact matching.
LookupAssignmentSK	12	Looks up values in a reference dataset by using exact matching.
LookupPositionSK	12	Looks up values in a reference dataset by using exact matching.
OLE DB Load into FactHoursByWeek	10	OLE DB Destination
OLE_SRC Attendance Data if reporting by Day From Operations	9	OLE DB Source

Component	Input Column	Destination Column
Check for SK Nulls
Derived Column Input
	AssignmentSK [?]	AssignmentSK
	EmployeeSK [?]	EmployeeSK
	PositionSK [?]	PositionSK
	TimeTypeSK [?]	TimeTypeSK
Lookup EmployeeSK
Lookup Input
	EmployeeAK [?]	EmployeeAK
Lookup TimeTypeSK
Lookup Input
	TimeTypeAK [?]	TimeTypeAK
LookupAssignmentSK
Lookup Input
	AssignmentAK [?]	AssignmentAK
LookupPositionSK
Lookup Input
	PositionAK [?]	PositionAK
OLE DB Load into FactHoursByWeek
OLE DB Destination Input
	AssignmentSK [?]	AssignmentSK
	EmployeeSK [?]	EmployeeSK
	EndDateSK [?]	EndDateSK
	HoursWorked [?]	HoursWorked
	PositionSK [?]	PositionSK
	StartDateSK [?]	StartDateSK
	TimeTypeSK [?]	TimeTypeSK

Name

Value

Description