|
![]() |
Property | Value |
Name | Merge_Join to LookUp SK for GLDetail |
Description | Merges data from two datasets by using a join. |
Up Stream Components | |
Down Stream Components | |
ID | 1599 |
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 to LookUp SK for GLDetail" (1599) |
Is Default Locale | True |
Pipeline Version | 0 |
Uses Dispositions | False |
Validate External Metadata | True |
Version | 1 |
Name | Connection Manager | Description |
Name | Value |
JoinType |
1 |
MaxBuffersPerInput |
5 |
NumKeyColumns |
1 |
TreatNullsAsEqual |
True |
Name | ID | LineageID |
ActualsAmount |
1699 |
1176 |
BudgetAmount |
1690 |
1167 |
CalendarPeriodDate |
1670 |
1146 |
CommitmentAmount |
1693 |
1170 |
EncumbranceAmount |
1696 |
1173 |
GlCodeAK |
1684 |
1161 |
GlDetailAK |
1663 |
1155 |
JournalAmount |
1687 |
1164 |
OrgUnitAK |
1681 |
1158 |
PostedDate |
1673 |
1149 |
YearGlAccountNumberAK |
1676 |
1152 |
GlDetailAK |
1665 |
1627 |
GlDetailSK |
1788 |
1786 |
Name | ID | LineageID |
ActualsAmount |
1700 |
1700 |
BudgetAmount |
1691 |
1691 |
CalendarPeriodDate |
1671 |
1671 |
CommitmentAmount |
1694 |
1694 |
EncumbranceAmount |
1697 |
1697 |
GlCodeAK |
1685 |
1685 |
GlDetailAK |
1679 |
1679 |
GlDetailSK |
1789 |
1789 |
JournalAmount |
1688 |
1688 |
OrgUnitAK |
1682 |
1682 |
PostedDate |
1674 |
1674 |
YearGlAccountNumberAK |
1677 |
1677 |
Powered by BI Documenter |