|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF Case Transform |
| Description | The case transformation corrects, cases and standardizes names, addresses or any text to proper case for any input columns data. |
| Up Stream Components | |
| Down Stream Components | |
| ID | 3715 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | TF Name Parse Transform; Pragmatic Works, Inc; Task Factory (c) 2011 Pragmatic Works, Inc; http://www.pragmaticworks.com;support@pragmaticworks.com |
| Identification String | component "TF Case Transform" (3715) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | True |
| Validate External Metadata | True |
| Version | 1 |
Connections
| Name | Connection Manager | Description |
Custom Properties
| Name | Value |
UserComponentTypeName |
PW.TaskFactory.CaseAndStandardizationTransform.CaseAndStandardizationTransform, PW.TaskFactory100, Version=1.0.0.0, Culture=neutral, PublicKeyToken=47acf905d0337c39 |
Input Columns
| Name | ID | LineageID |
BudgetManager |
6634 |
6478 |
BudgetManagerId |
6633 |
6475 |
ControlOrgUnit |
6631 |
6469 |
ControlOrgUnitName |
6632 |
6472 |
EndDate |
6644 |
6508 |
FunctionCode |
6624 |
6448 |
FunctionDescription |
6625 |
6451 |
Fund |
6623 |
6445 |
FundCode |
6622 |
6442 |
Location |
6629 |
6463 |
LocationCode |
6628 |
6460 |
OrgUnit |
6618 |
6430 |
OrgUnitAK |
6617 |
6427 |
OrgUnitGrouping |
6642 |
6502 |
OrgUnitName |
6619 |
6433 |
OrgUnitStatus |
6621 |
6439 |
OrgUnitStatusCode |
6620 |
6436 |
PrincipalAdmin |
6638 |
6490 |
PrincipalAdminId |
6637 |
6487 |
ProjectNumber |
6639 |
6493 |
Qual1 |
6630 |
6466 |
ReportDistribution |
6641 |
6499 |
ReportDistributionCode |
6640 |
6496 |
RowIsDuplicate |
6645 |
6511 |
RowIsSelected |
6646 |
6514 |
StartDate |
6643 |
6505 |
StateOrgUnit |
7275 |
7270 |
SubFunction |
6627 |
6457 |
SubFunctionCode |
6626 |
6454 |
UserGroup |
6636 |
6484 |
UserGroupId |
6635 |
6481 |
VerifyOrgUnitSK |
6616 |
6424 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
3720 |
3720 |
ErrorColumn |
3721 |
3721 |
| Powered by BI Documenter |
