FactGlTransactionsLoad
 Merge_Join to LookUp SK for GLDetail (Component)
  Properties
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
  Connections
Name Connection Manager Description
  Custom Properties
Name Value
JoinType
1
MaxBuffersPerInput
5
NumKeyColumns
1
TreatNullsAsEqual
True
  Input Columns
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
  Output Columns
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