|
|
||||||
|
|
||||||
DataFlow Screenshot
Properties
| Property | Value |
| Name | DFT Load Temp Curriculum Tables from Staging |
| Description | Data Flow Task |
| Precedence Executables | none |
| Contrained Executables | none |
| ID | 30fd617f-7190-4dcf-9285-24f754f1808f |
| 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 |
|
10 |
OLE DB Destination |
|
9 |
OLE DB Source |
|
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. |
|
12 |
Column Mappings
| Component | Input Column | Destination Column | |
OLE_DST Load New Temp Table for Curriculum |
|||
OLE DB Destination Input |
|||
Apprenticeship [?] |
 |
Apprenticeship |
|
Campus [?] |
|
Campus |
|
CampusCode [?] |
|
CampusCode |
|
Center [?] |
|
Center |
|
CenterCode [?] |
|
CenterCode |
|
ClassStatus [?] |
|
ClassStatus |
|
ClassStatusCode [?] |
|
ClassStatusCode |
|
ClassTitle [?] |
|
ClassTitle |
|
CourseId [?] |
|
CourseId |
|
CourseIdPrefix [?] |
|
CourseIdPrefix |
|
CourseLevel [?] |
|
CourseLevel |
|
CourseNumberTimesForCredit [?] |
|
CourseNumberTimesForCredit |
|
CourseType [?] |
|
CourseType |
|
CourseTypeCode [?] |
|
CourseTypeCode |
|
CreditNonCredit [?] |
|
CreditNonCredit |
|
CreditNonCreditVocational [?] |
|
CreditNonCreditVocational |
|
CreditNonCreditVocationalTest [?] |
|
CreditNonCreditVocationalTest |
|
CreditType [?] |
|
CreditType |
|
CreditTypeCode [?] |
|
CreditTypeCode |
|
CurrentCourseId [?] |
|
CurrentCourseId |
|
CurrentTerm [?] |
|
CurrentTerm |
|
DeliveryMethod [?] |
|
DeliveryMethod |
|
Department [?] |
|
Department |
|
DepartmentCode [?] |
|
DepartmentCode |
|
DepartmentDescription [?] |
|
DepartmentDescription |
|
Division [?] |
|
Division |
|
DivisionCode [?] |
|
DivisionCode |
|
DivisionDescription [?] |
|
DivisionDescription |
|
DualEnrollment [?] |
|
DualEnrollment |
|
Honors [?] |
|
Honors |
|
ICSCategoryCode [?] |
|
ICSCategoryCode |
|
ICSCode [?] |
|
ICSCode |
|
IndependentStudy [?] |
|
IndependentStudy |
|
InstructionalClassification [?] |
|
InstructionalClassification |
|
InstructionalClassificationCategory [?] |
|
InstructionalClassificationCategory |
|
IsCourseRepeatable [?] |
|
IsCourseRepeatable |
|
IsTermCourseIdCountGE10 [?] |
|
IsTermCourseIdCountGE10 |
|
MaximumClassSize [?] |
|
MaximumClassSize |
|
MinimumClassSize [?] |
|
MinimumClassSize |
|
Online100Percent [?] |
|
Online100Percent |
|
PrimaryInstructor [?] |
|
PrimaryInstructorId |
|
PrimaryInstructorFirstName [?] |
|
PrimaryInstructorFirstName |
|
PrimaryInstructorFullName [?] |
|
PrimaryInstructorFullName |
|
PrimaryInstructorInitial [?] |
|
PrimaryInstructorMiddleInitial |
|
PrimaryInstructorLastName [?] |
|
PrimaryInstructorLastName |
|
PrimaryInstructorType [?] |
|
PrimaryInstructorType |
|
ReferenceNumber [?] |
|
ReferenceNumber |
|
ReferenceNumberAK [?] |
|
ReferenceNumberAK |
|
RowEndDate [?] |
|
RowEndDate |
|
RowIsCurrent [?] |
|
RowIsCurrent |
|
RowStartDate [?] |
|
RowStartDate |
|
ScheduleInformation [?] |
|
ScheduleInformation |
|
Session [?] |
|
Session |
|
SessionCode [?] |
|
SessionCode |
|
Term [?] |
|
Term |
|
TermCourseIdCount [?] |
|
TermCourseIdCount |
|
TermTitle [?] |
|
TermTitle |
|
TimeBlock [?] |
|
TimeBlock |
|
TimeBlockCode [?] |
|
TimeBlockCode |
|
VirtualCollege [?] |
|
VirtualCollege |
|
WebBlended [?] |
|
WebBlended |
|
WebEnabled [?] |
|
WebEnabled |
|
WeekendCollege [?] |
|
WeekendCollege |
|
OLE_DST Load SCD1 Temp Table for Curriculum |
|||
OLE DB Destination Input |
|||
Apprenticeship [?] |
|
Apprenticeship |
|
Campus [?] |
|
Campus |
|
CampusCode [?] |
|
CampusCode |
|
Center [?] |
|
Center |
|
CenterCode [?] |
|
CenterCode |
|
ClassStatus [?] |
|
ClassStatus |
|
ClassStatusCode [?] |
|
ClassStatusCode |
|
ClassTitle [?] |
|
ClassTitle |
|
CourseId [?] |
|
CourseId |
|
CourseIdPrefix [?] |
|
CourseIdPrefix |
|
CourseLevel [?] |
|
CourseLevel |
|
CourseNumberTimesForCredit [?] |
|
CourseNumberTimesForCredit |
|
CourseType [?] |
|
CourseType |
|
CourseTypeCode [?] |
|
CourseTypeCode |
|
CreditNonCredit [?] |
|
CreditNonCredit |
|
CreditNonCreditVocational [?] |
|
CreditNonCreditVocational |
|
CreditNonCreditVocationalTest [?] |
|
CreditNonCreditVocationalTest |
|
CreditType [?] |
|
CreditType |
|
CreditTypeCode [?] |
|
CreditTypeCode |
|
CurrentCourseId [?] |
|
CurrentCourseId |
|
CurrentTerm [?] |
|
CurrentTerm |
|
CurriculumSK [?] |
|
CurriculumSK |
|
DeliveryMethod [?] |
|
DeliveryMethod |
|
Department [?] |
|
Department |
|
DepartmentCode [?] |
|
DepartmentCode |
|
DepartmentDescription [?] |
|
DepartmentDescription |
|
Division [?] |
|
Division |
|
DivisionCode [?] |
|
DivisionCode |
|
DivisionDescription [?] |
|
DivisionDescription |
|
DualEnrollment [?] |
|
DualEnrollment |
|
Honors [?] |
|
Honors |
|
ICSCategoryCode [?] |
|
ICSCategoryCode |
|
ICSCode [?] |
|
ICSCode |
|
IndependentStudy [?] |
|
IndependentStudy |
|
InstructionalClassification [?] |
|
InstructionalClassification |
|
InstructionalClassificationCategory [?] |
|
InstructionalClassificationCategory |
|
IsCourseRepeatable [?] |
|
IsCourseRepeatable |
|
IsTermCourseIdCountGE10 [?] |
|
IsTermCourseIdCountGE10 |
|
MaximumClassSize [?] |
|
MaximumClassSize |
|
MinimumClassSize [?] |
|
MinimumClassSize |
|
Online100Percent [?] |
|
Online100Percent |
|
PrimaryInstructor [?] |
|
PrimaryInstructorId |
|
PrimaryInstructorFirstName [?] |
|
PrimaryInstructorFirstName |
|
PrimaryInstructorFullName [?] |
|
PrimaryInstructorFullName |
|
PrimaryInstructorInitial [?] |
|
PrimaryInstructorMiddleInitial |
|
PrimaryInstructorLastName [?] |
|
PrimaryInstructorLastName |
|
PrimaryInstructorType [?] |
|
PrimaryInstructorType |
|
ReferenceNumber [?] |
|
ReferenceNumber |
|
ReferenceNumberAK [?] |
|
ReferenceNumberAK |
|
ScheduleInformation [?] |
|
ScheduleInformation |
|
Session [?] |
|
Session |
|
SessionCode [?] |
|
SessionCode |
|
Term [?] |
|
Term |
|
TermCourseIdCount [?] |
|
TermCourseIdCount |
|
TermTitle [?] |
|
TermTitle |
|
TimeBlock [?] |
|
TimeBlock |
|
TimeBlockCode [?] |
|
TimeBlockCode |
|
VirtualCollege [?] |
|
VirtualCollege |
|
WebBlended [?] |
|
WebBlended |
|
WebEnabled [?] |
|
WebEnabled |
|
WeekendCollege [?] |
|
WeekendCollege |
|
TF Case Transform |
|||
Name Parse Input |
|||
Apprenticeship [?] |
|
Apprenticeship |
|
Campus [?] |
|
Campus |
|
CampusCode [?] |
|
CampusCode |
|
Center [?] |
|
Center |
|
CenterCode [?] |
|
CenterCode |
|
ClassStatus [?] |
|
ClassStatus |
|
ClassStatusCode [?] |
|
ClassStatusCode |
|
ClassTitle [?] |
|
ClassTitle |
|
CourseId [?] |
|
CourseId |
|
CourseIdPrefix [?] |
|
CourseIdPrefix |
|
CourseLevel [?] |
|
CourseLevel |
|
CourseNumberTimesForCredit [?] |
|
CourseNumberTimesForCredit |
|
CourseType [?] |
|
CourseType |
|
CourseTypeCode [?] |
|
CourseTypeCode |
|
CreditNonCredit [?] |
|
CreditNonCredit |
|
CreditNonCreditVocational [?] |
|
CreditNonCreditVocational |
|
CreditNonCreditVocationalTest [?] |
|
CreditNonCreditVocationalTest |
|
CreditType [?] |
|
CreditType |
|
CreditTypeCode [?] |
|
CreditTypeCode |
|
CurrentCourseId [?] |
|
CurrentCourseId |
|
CurrentTerm [?] |
|
CurrentTerm |
|
DeliveryMethod [?] |
|
DeliveryMethod |
|
Department [?] |
|
Department |
|
DepartmentCode [?] |
|
DepartmentCode |
|
DepartmentDescription [?] |
|
DepartmentDescription |
|
Division [?] |
|
Division |
|
DivisionCode [?] |
|
DivisionCode |
|
DivisionDescription [?] |
|
DivisionDescription |
|
DualEnrollment [?] |
|
DualEnrollment |
|
Honors [?] |
|
Honors |
|
ICSCategoryCode [?] |
|
ICSCategoryCode |
|
ICSCode [?] |
|
ICSCode |
|
IndependentStudy [?] |
|
IndependentStudy |
|
InstructionalClassification [?] |
|
InstructionalClassification |
|
InstructionalClassificationCategory [?] |
|
InstructionalClassificationCategory |
|
IsCourseRepeatable [?] |
|
IsCourseRepeatable |
|
IsTermCourseIdCountGE10 [?] |
|
IsTermCourseIdCountGE10 |
|
MaximumClassSize [?] |
|
MaximumClassSize |
|
MinimumClassSize [?] |
|
MinimumClassSize |
|
Online100Percent [?] |
|
Online100Percent |
|
PrimaryInstructorFirstName [?] |
|
PrimaryInstructorFirstName |
|
PrimaryInstructorFullName [?] |
|
PrimaryInstructorFullName |
|
PrimaryInstructorId [?] |
|
PrimaryInstructorId |
|
PrimaryInstructorLastName [?] |
|
PrimaryInstructorLastName |
|
PrimaryInstructorMiddleInitial [?] |
|
PrimaryInstructorMiddleInitial |
|
PrimaryInstructorType [?] |
|
PrimaryInstructorType |
|
ReferenceNumber [?] |
|
ReferenceNumber |
|
ReferenceNumberAK [?] |
|
ReferenceNumberAK |
|
ScheduleInformation [?] |
|
ScheduleInformation |
|
Session [?] |
|
Session |
|
SessionCode [?] |
|
SessionCode |
|
Term [?] |
|
Term |
|
TermCourseIdCount [?] |
|
TermCourseIdCount |
|
TermTitle [?] |
|
TermTitle |
|
TimeBlock [?] |
|
TimeBlock |
|
TimeBlockCode [?] |
|
TimeBlockCode |
|
VerifyCurriculumSK [?] |
|
VerifyCurriculumSK |
|
VirtualCollege [?] |
|
VirtualCollege |
|
WebBlended [?] |
|
WebBlended |
|
WebEnabled [?] |
|
WebEnabled |
|
WeekendCollege [?] |
|
WeekendCollege |
|
TF_SCD Curriculum Slowly Changing Dimension Process |
|||
Existing Dimension |
|||
Apprenticeship [?] |
|
Apprenticeship |
|
Campus [?] |
|
Campus |
|
CampusCode [?] |
|
CampusCode |
|
Center [?] |
|
Center |
|
CenterCode [?] |
|
CenterCode |
|
ClassStatus [?] |
|
ClassStatus |
|
ClassStatusCode [?] |
|
ClassStatusCode |
|
ClassTitle [?] |
|
ClassTitle |
|
CourseId [?] |
|
CourseId |
|
CourseIdPrefix [?] |
|
CourseIdPrefix |
|
CourseLevel [?] |
|
CourseLevel |
|
CourseNumberTimesForCredit [?] |
|
CourseNumberTimesForCredit |
|
CourseType [?] |
|
CourseType |
|
CourseTypeCode [?] |
|
CourseTypeCode |
|
CreditNonCredit [?] |
|
CreditNonCredit |
|
CreditNonCreditVocational [?] |
|
CreditNonCreditVocational |
|
CreditNonCreditVocationalTest [?] |
|
CreditNonCreditVocationalTest |
|
CreditType [?] |
|
CreditType |
|
CreditTypeCode [?] |
|
CreditTypeCode |
|
CurrentCourseId [?] |
|
CurrentCourseId |
|
CurrentTerm [?] |
|
CurrentTerm |
|
CurriculumSK [?] |
|
CurriculumSK |
|
DeliveryMethod [?] |
|
DeliveryMethod |
|
Department [?] |
|
Department |
|
DepartmentCode [?] |
|
DepartmentCode |
|
DepartmentDescription [?] |
|
DepartmentDescription |
|
Division [?] |
|
Division |
|
DivisionCode [?] |
|
DivisionCode |
|
DivisionDescription [?] |
|
DivisionDescription |
|
DualEnrollment [?] |
|
DualEnrollment |
|
Honors [?] |
|
Honors |
|
ICSCategoryCode [?] |
|
ICSCategoryCode |
|
ICSCode [?] |
|
ICSCode |
|
IndependentStudy [?] |
|
IndependentStudy |
|
InstructionalClassification [?] |
|
InstructionalClassification |
|
InstructionalClassificationCategory [?] |
|
InstructionalClassificationCategory |
|
IsCourseRepeatable [?] |
|
IsCourseRepeatable |
|
IsTermCourseIdCountGE10 [?] |
|
IsTermCourseIdCountGE10 |
|
MaximumClassSize [?] |
|
MaximumClassSize |
|
MinimumClassSize [?] |
|
MinimumClassSize |
|
Online100Percent [?] |
|
Online100Percent |
|
PrimaryInstructor [?] |
|
PrimaryInstructor |
|
PrimaryInstructorFirstName [?] |
|
PrimaryInstructorFirstName |
|
PrimaryInstructorFullName [?] |
|
PrimaryInstructorFullName |
|
PrimaryInstructorInitial [?] |
|
PrimaryInstructorInitial |
|
PrimaryInstructorLastName [?] |
|
PrimaryInstructorLastName |
|
PrimaryInstructorType [?] |
|
PrimaryInstructorType |
|
ReferenceNumber [?] |
|
ReferenceNumber |
|
ReferenceNumberAK [?] |
|
ReferenceNumberAK |
|
RowEndDate [?] |
|
RowEndDate |
|
RowIsCurrent [?] |
|
RowIsCurrent |
|
RowStartDate [?] |
|
RowStartDate |
|
ScheduleInformation [?] |
|
ScheduleInformation |
|
Session [?] |
|
Session |
|
SessionCode [?] |
|
SessionCode |
|
Term [?] |
|
Term |
|
TermCourseIdCount [?] |
|
TermCourseIdCount |
|
TermTitle [?] |
|
TermTitle |
|
TimeBlock [?] |
|
TimeBlock |
|
TimeBlockCode [?] |
|
TimeBlockCode |
|
VirtualCollege [?] |
|
VirtualCollege |
|
WebBlended [?] |
|
WebBlended |
|
WebEnabled [?] |
|
WebEnabled |
|
WeekendCollege [?] |
|
WeekendCollege |
|
Source System |
|||
Apprenticeship [?] |
|
Apprenticeship |
|
Campus [?] |
|
Campus |
|
CampusCode [?] |
|
CampusCode |
|
Center [?] |
|
Center |
|
CenterCode [?] |
|
CenterCode |
|
ClassStatus [?] |
|
ClassStatus |
|
ClassStatusCode [?] |
|
ClassStatusCode |
|
ClassTitle [?] |
|
ClassTitle |
|
CourseId [?] |
|
CourseId |
|
CourseIdPrefix [?] |
|
CourseIdPrefix |
|
CourseLevel [?] |
|
CourseLevel |
|
CourseNumberTimesForCredit [?] |
|
CourseNumberTimesForCredit |
|
CourseType [?] |
|
CourseType |
|
CourseTypeCode [?] |
|
CourseTypeCode |
|
CreditNonCredit [?] |
|
CreditNonCredit |
|
CreditNonCreditVocational [?] |
|
CreditNonCreditVocational |
|
CreditNonCreditVocationalTest [?] |
|
CreditNonCreditVocationalTest |
|
CreditType [?] |
|
CreditType |
|
CreditTypeCode [?] |
|
CreditTypeCode |
|
CurrentCourseId [?] |
|
CurrentCourseId |
|
CurrentTerm [?] |
|
CurrentTerm |
|
DeliveryMethod [?] |
|
DeliveryMethod |
|
Department [?] |
|
Department |
|
DepartmentCode [?] |
|
DepartmentCode |
|
DepartmentDescription [?] |
|
DepartmentDescription |
|
Division [?] |
|
Division |
|
DivisionCode [?] |
|
DivisionCode |
|
DivisionDescription [?] |
|
DivisionDescription |
|
DualEnrollment [?] |
|
DualEnrollment |
|
Honors [?] |
|
Honors |
|
ICSCategoryCode [?] |
|
ICSCategoryCode |
|
ICSCode [?] |
|
ICSCode |
|
IndependentStudy [?] |
|
IndependentStudy |
|
InstructionalClassification [?] |
|
InstructionalClassification |
|
InstructionalClassificationCategory [?] |
|
InstructionalClassificationCategory |
|
IsCourseRepeatable [?] |
|
IsCourseRepeatable |
|
IsTermCourseIdCountGE10 [?] |
|
IsTermCourseIdCountGE10 |
|
MaximumClassSize [?] |
|
MaximumClassSize |
|
MinimumClassSize [?] |
|
MinimumClassSize |
|
Online100Percent [?] |
|
Online100Percent |
|
PrimaryInstructorFirstName [?] |
|
PrimaryInstructorFirstName |
|
PrimaryInstructorFullName [?] |
|
PrimaryInstructorFullName |
|
PrimaryInstructorId [?] |
|
PrimaryInstructorId |
|
PrimaryInstructorLastName [?] |
|
PrimaryInstructorLastName |
|
PrimaryInstructorMiddleInitial [?] |
|
PrimaryInstructorMiddleInitial |
|
PrimaryInstructorType [?] |
|
PrimaryInstructorType |
|
ReferenceNumber [?] |
|
ReferenceNumber |
|
ReferenceNumberAK [?] |
|
ReferenceNumberAK |
|
ScheduleInformation [?] |
|
ScheduleInformation |
|
Session [?] |
|
Session |
|
SessionCode [?] |
|
SessionCode |
|
Term [?] |
|
Term |
|
TermCourseIdCount [?] |
|
TermCourseIdCount |
|
TermTitle [?] |
|
TermTitle |
|
TimeBlock [?] |
|
TimeBlock |
|
TimeBlockCode [?] |
|
TimeBlockCode |
|
VirtualCollege [?] |
|
VirtualCollege |
|
WebBlended [?] |
|
WebBlended |
|
WebEnabled [?] |
|
WebEnabled |
|
WeekendCollege [?] |
|
WeekendCollege |
|
Variables
| Name | Value | Description |
| Powered by BI Documenter |
