|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | LKP Source Employee AK |
| Description | Looks up values in a reference dataset by using exact matching. |
| Up Stream Components | |
| Down Stream Components | |
| ID | 19 |
| Component Class ID | {27648839-180F-45E6-838D-AFF53DF682D2} |
| Contact Info | Lookup;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5 |
| Identification String | component "LKP Source Employee AK" (19) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | True |
| Validate External Metadata | True |
| Version | 5 |
Connections
| Name | Connection Manager | Description |
OleDbConnection |
Custom Properties
| Name | Value |
CacheType |
0 |
ConnectionType |
0 |
DefaultCodePage |
1252 |
MaxMemoryUsage |
25 |
MaxMemoryUsage64 |
25 |
NoMatchBehavior |
1 |
NoMatchCachePercentage |
0 |
ParameterMap |
#319; |
ReferenceMetadataXml |
<referenceMetadata><referenceColumns><referenceColumn name="EmployeeAK" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata> |
SqlCommand |
SELECT DISTINCT PERSON_ID AS EmployeeAK FROM EMPLOYEE_A WHERE PERSON_ID IS NOT NULL UNION SELECT DISTINCT NonEmp.PERSON_ID AS EmployeeAK FROM NON_EMPLOYEE_A NonEmp CROSS APPLY ( SELECT TOP 1 NonEmpAssign.POSITION_CODE FROM ASSIGNMENT_A NonEmpAssign WHERE NonEmpAssign.PERSON_ID = NonEmp.PERSON_ID ) IsNonEmployee LEFT OUTER JOIN EMPLOYEE_A EmpCheck ON ( EmpCheck.PERSON_ID = NonEmp.PERSON_ID ) WHERE NonEmp.PERSON_ID IS NOT NULL AND EmpCheck.PERSON_ID IS NULL |
SqlCommandParam |
select * from (SELECT DISTINCT
PERSON_ID AS EmployeeAK
FROM EMPLOYEE_A
WHERE PERSON_ID IS NOT NULL
UNION
SELECT DISTINCT
NonEmp.PERSON_ID AS EmployeeAK
FROM NON_EMPLOYEE_A NonEmp
CROSS APPLY
(
SELECT TOP 1
NonEmpAssign.POSITION_CODE
FROM ASSIGNMENT_A NonEmpAssign
WHERE NonEmpAssign.PERSON_ID = NonEmp.PERSON_ID
) IsNonEmployee
LEFT OUTER JOIN EMPLOYEE_A EmpCheck
ON
(
EmpCheck.PERSON_ID = NonEmp.PERSON_ID
)
WHERE NonEmp.PERSON_ID IS NOT NULL
AND EmpCheck.PERSON_ID IS NULL) [refTable]
where [refTable].[EmployeeAK] = ? |
Input Columns
| Name | ID | LineageID |
EmployeeAK |
321 |
319 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
36 |
36 |
ErrorColumn |
37 |
37 |
| Powered by BI Documenter |
