DimCurriculumLoad
 SCD1UpdateDimCurriculum (Variable)
Home  Diagrams  Documents  Images  DimCurriculumLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimCurriculumLoad   Variables   SCD1UpdateDimCurriculum
  Properties
Property Value
Name SCD1UpdateDimCurriculum
Value Expression: " /* SQL Update DimCurriculum from temp table */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCurriculum] SET ReferenceNumberAK = SCD1.ReferenceNumberAK ,ReferenceNumber = SCD1.ReferenceNumber ,Term = SCD1.Term ,TermTitle = SCD1.TermTitle ,CourseId = SCD1.CourseId ,CurrentTerm = SCD1.CurrentTerm ,CurrentCourseId = SCD1.CurrentCourseId ,CourseIdPrefix = SCD1.CourseIdPrefix ,ClassTitle = SCD1.ClassTitle ,CourseTypeCode = SCD1.CourseTypeCode ,CourseType = SCD1.CourseType ,CreditNonCreditVocational = SCD1.CreditNonCreditVocational ,CreditTypeCode = SCD1.CreditTypeCode ,CreditType = SCD1.CreditType ,CreditNonCredit = SCD1.CreditNonCredit ,ICSCode = SCD1.ICSCode ,InstructionalClassification = SCD1.InstructionalClassification

/* SQL Update DimCurriculum from temp table */ UPDATE [EnterpriseDW].[dbo].[DimCurriculum] SET ReferenceNumberAK = SCD1.ReferenceNumberAK ,ReferenceNumber = SCD1.ReferenceNumber ,Term = SCD1.Term ,TermTitle = SCD1.TermTitle ,CourseId = SCD1.CourseId ,CurrentTerm = SCD1.CurrentTerm ,CurrentCourseId = SCD1.CurrentCourseId ,CourseIdPrefix = SCD1.CourseIdPrefix ,ClassTitle = SCD1.ClassTitle ,CourseTypeCode = SCD1.CourseTypeCode ,CourseType = SCD1.CourseType ,CreditNonCreditVocational = SCD1.CreditNonCreditVocational ,CreditTypeCode = SCD1.CreditTypeCode ,CreditType = SCD1.CreditType ,CreditNonCredit = SCD1.CreditNonCredit ,ICSCode = SCD1.ICSCode ,InstructionalClassification = SCD1.InstructionalClassification ,DivisionCode = SCD1.DivisionCode ,Division = SCD1.Division ,DepartmentCode = SCD1.DepartmentCode ,Department = SCD1.Department ,CampusCode = SCD1.CampusCode ,Campus = SCD1.Campus ,CenterCode = SCD1.CenterCode ,Center = SCD1.Center ,MinimumClassSize = SCD1.MinimumClassSize ,MaximumClassSize = SCD1.MaximumClassSize ,ClassStatusCode = SCD1.ClassStatusCode ,ClassStatus = SCD1.ClassStatus ,TimeBlockCode = SCD1.TimeBlockCode ,TimeBlock = SCD1.TimeBlock ,DeliveryMethod = SCD1.DeliveryMethod ,PrimaryInstructorId = SCD1.PrimaryInstructorId ,PrimaryInstructorFullName = SCD1.PrimaryInstructorFullName ,PrimaryInstructorLastName = SCD1.PrimaryInstructorLastName ,PrimaryInstructorFirstName = SCD1.PrimaryInstructorFirstName ,PrimaryInstructorMiddleInitial = SCD1.PrimaryInstructorMiddleInitial ,SessionCode = SCD1.SessionCode ,[Session] = SCD1.[Session] ,Honors = SCD1.Honors ,WeekendCollege = SCD1.WeekendCollege ,DualEnrollment = SCD1.DualEnrollment ,IndependentStudy = SCD1.IndependentStudy ,Apprenticeship = SCD1.Apprenticeship ,VirtualCollege = SCD1.VirtualCollege ,Online100Percent = SCD1.Online100Percent ,WebEnabled = SCD1.WebEnabled ,WebBlended = SCD1.WebBlended ,ScheduleInformation = SCD1.ScheduleInformation ,PrimaryInstructorType = SCD1.PrimaryInstructorType ,ICSCategoryCode = SCD1.ICSCategoryCode ,InstructionalClassificationCategory = SCD1.InstructionalClassificationCategory ,TermCourseIdCount = SCD1.TermCourseIdCount ,IsTermCourseIdCountGE10 = SCD1.IsTermCourseIdCountGE10 ,IsCourseRepeatable = SCD1.IsCourseRepeatable ,CourseNumberTimesForCredit = SCD1.CourseNumberTimesForCredit ,CourseLevel = SCD1.CourseLevel ,CreditNonCreditVocationalTest = SCD1.CreditNonCreditVocationalTest,DivisionDescription = SCD1.DivisionDescription ,DepartmentDescription = SCD1.DepartmentDescription FROM [EnterpriseDW].[dbo].[DimCurriculum] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimCurriculum__Type1Update] AS SCD1 ON Dim.ReferenceNumberAK = SCD1.ReferenceNumberAK
Value Type String
Description This is the SQL update statement for DimCurriculum
System Variable False
Namespace User
Qualified Name User::SCD1UpdateDimCurriculum
Evaluate As Expression True
Expression " /* SQL Update DimCurriculum from temp table */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCurriculum] SET ReferenceNumberAK = SCD1.ReferenceNumberAK ,ReferenceNumber = SCD1.ReferenceNumber ,Term = SCD1.Term ,TermTitle = SCD1.TermTitle ,CourseId = SCD1.CourseId ,CurrentTerm = SCD1.CurrentTerm ,CurrentCourseId = SCD1.CurrentCourseId ,CourseIdPrefix = SCD1.CourseIdPrefix ,ClassTitle = SCD1.ClassTitle ,CourseTypeCode = SCD1.CourseTypeCode ,CourseType = SCD1.CourseType ,CreditNonCreditVocational = SCD1.CreditNonCreditVocational ,CreditTypeCode = SCD1.CreditTypeCode ,CreditType = SCD1.CreditType ,CreditNonCredit = SCD1.CreditNonCredit ,ICSCode = SCD1.ICSCode ,InstructionalClassification = SCD1.InstructionalClassification
ID 1ed3fb54-971b-4a51-a4de-07dcbcb5b0e4
Raise Changed Event False
Powered by BI Documenter