FactEnrollmentSnapshotLoad
 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
EFF_TRM
569
1124
Enrolled
572
1133
EnrollmentDate
587
1130
EnrollmentDateSK
1145
1139
PaidEnrollment
575
1136
REF_NUM
565
1127
STDNT_ID
566
1121
ClockHours
383
353
CreditHours
380
350
FTE
386
356
REF_NUM
72
53
  Output Columns
Name ID LineageID
ClockHours
384
384
CreditHours
381
381
EFF_TRM
570
570
Enrolled
573
573
EnrollmentDate
588
588
EnrollmentDateSK
1146
1146
FTE
387
387
PaidEnrollment
576
576
REF_NUM
581
581
STDNT_ID
567
567
Powered by BI Documenter