|
![]() |
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 |
Name | Connection Manager | Description |
Name | Value |
JoinType |
2 |
MaxBuffersPerInput |
5 |
NumKeyColumns |
1 |
TreatNullsAsEqual |
True |
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 |
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 |