FactPriorEnrollmentSnapshotLoad
 Merge Join (Component)
  Properties
Property Value
Name Merge Join
Description Merges data from two datasets by using a join.
Up Stream Components
Down Stream Components
ID 61
Component Class ID {A18A4D58-7C7A-4448-8B98-AE2CEFE81B4C}
Contact Info Merge Join;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1
Identification String component "Merge Join" (61)
Is Default Locale True
Pipeline Version 0
Uses Dispositions False
Validate External Metadata True
Version 1
  Connections
Name Connection Manager Description
  Custom Properties
Name Value
JoinType
2
MaxBuffersPerInput
5
NumKeyColumns
1
TreatNullsAsEqual
True
  Input Columns
Name ID LineageID
ActiveTerm
673
659
EFF_TRM
569
541
PriorEnrolled
682
668
PriorEnrollmentDate
679
665
PriorPaidEnrollment
685
671
PriorRelativeDay
676
662
REF_NUM
565
542
STDNT_ID
566
540
ClockHours
383
353
CreditHours
380
350
FTE
386
356
REF_NUM
72
53
  Output Columns
Name ID LineageID
ActiveTerm
674
674
ClockHours
384
384
CreditHours
381
381
EFF_TRM
570
570
FTE
387
387
PriorEnrolled
683
683
PriorEnrollmentDate
680
680
PriorPaidEnrollment
686
686
PriorRelativeDay
677
677
REF_NUM
581
581
STDNT_ID
567
567
Powered by BI Documenter