FactEOTEnrollmentSnapshotLoad
 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
541
EOTEnrolled
731
723
EOTEnrollmentDate
728
720
EOTPaidEnrollment
734
726
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
ClockHours
384
384
CreditHours
381
381
EFF_TRM
570
570
EOTEnrolled
732
732
EOTEnrollmentDate
729
729
EOTPaidEnrollment
735
735
FTE
387
387
REF_NUM
581
581
STDNT_ID
567
567
Powered by BI Documenter