|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TFCASE from Staging |
| 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 | 1 |
| 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 "TFCASE from Staging" (1) |
| Is Default Locale | False |
| 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 |
SCRPriorYearTerm |
13 |
48 |
SRCAcademicYear |
20 |
52 |
SRCAcademicYearCode |
19 |
51 |
SRCActiveTerm |
24 |
53 |
SRCDefaultTerm |
25 |
54 |
SRCRelativeDay |
143 |
141 |
SRCTermAK |
5 |
43 |
SRCTermEndDate |
7 |
45 |
SRCTermSK |
4 |
42 |
SRCTermStartDate |
6 |
44 |
SRCTermTitle |
8 |
46 |
SRCTermType |
15 |
50 |
SRCTermTypeCode |
14 |
49 |
SRCTermYear |
12 |
47 |
StateReportingTermSequence |
240 |
237 |
StateReportingTermYear |
239 |
234 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
28 |
28 |
ErrorColumn |
29 |
29 |
| Powered by BI Documenter |
