cluster.txt

*** data/V1.XML
--- data/V2.XML
***************
*** 1,5 ****
  <root>
! <POWERMART CREATION_DATE: "06/01/2018 13:55:55" REPOSITORY_VERSION: "181.90">
  <REPOSITORY NAME: "Support" VERSION: "181" CODEPAGE: "MS1252" DATABASETYPE: "Microsoft SQL Server">
  <FOLDER NAME: "TEST" GROUP: "" OWNER: "Administrator" SHARED: "NOTSHARED" DESCRIPTION: "" PERMISSIONS: "rwx---r--" UUID: "69446daa-1527-4213-b16b-db70e467b6e4">
  <CONFIG DESCRIPTION: "Default session configuration object" ISDEFAULT: "YES" NAME: "default_session_config" VERSIONNUMBER: "1">
--- 1,5 ----
  <root>
! <POWERMART CREATION_DATE: "06/06/2018 13:21:13" REPOSITORY_VERSION: "181.90">
  <REPOSITORY NAME: "Support" VERSION: "181" CODEPAGE: "MS1252" DATABASETYPE: "Microsoft SQL Server">
  <FOLDER NAME: "TEST" GROUP: "" OWNER: "Administrator" SHARED: "NOTSHARED" DESCRIPTION: "" PERMISSIONS: "rwx---r--" UUID: "69446daa-1527-4213-b16b-db70e467b6e4">
  <CONFIG DESCRIPTION: "Default session configuration object" ISDEFAULT: "YES" NAME: "default_session_config" VERSIONNUMBER: "1">
***************
*** 44,88 ****
  <ATTRIBUTE NAME: "Writer Commit Statistics Log Interval" VALUE: "0"/>
  </CONFIG>
  <MAPPING DESCRIPTION: "" ISVALID: "YES" NAME: "m_TEST_DB_FF" OBJECTVERSION: "1" VERSIONNUMBER: "1">
! <CONNECTOR FROMFIELD: "deptno" FROMINSTANCE: "AGG_LOAD" FROMINSTANCETYPE: "Aggregator" TOFIELD: "deptno" TOINSTANCE: "TEST_details_tgt" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "deptno" FROMINSTANCE: "SQ_details" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "deptno" TOINSTANCE: "AGG_LOAD" TOINSTANCETYPE: "Aggregator"/>
! <CONNECTOR FROMFIELD: "deptno" FROMINSTANCE: "TEST_details" FROMINSTANCETYPE: "Source Definition" TOFIELD: "deptno" TOINSTANCE: "SQ_details" TOINSTANCETYPE: "Source Qualifier"/>
! <CONNECTOR FROMFIELD: "name" FROMINSTANCE: "AGG_LOAD" FROMINSTANCETYPE: "Aggregator" TOFIELD: "name" TOINSTANCE: "TEST_details_tgt" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "name" FROMINSTANCE: "SQ_details" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "name" TOINSTANCE: "AGG_LOAD" TOINSTANCETYPE: "Aggregator"/>
! <CONNECTOR FROMFIELD: "name" FROMINSTANCE: "TEST_details" FROMINSTANCETYPE: "Source Definition" TOFIELD: "name" TOINSTANCE: "SQ_details" TOINSTANCETYPE: "Source Qualifier"/>
! <CONNECTOR FROMFIELD: "salary" FROMINSTANCE: "AGG_LOAD" FROMINSTANCETYPE: "Aggregator" TOFIELD: "salary" TOINSTANCE: "TEST_details_tgt" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "salary" FROMINSTANCE: "SQ_details" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "salary" TOINSTANCE: "AGG_LOAD" TOINSTANCETYPE: "Aggregator"/>
! <CONNECTOR FROMFIELD: "salary" FROMINSTANCE: "TEST_details" FROMINSTANCETYPE: "Source Definition" TOFIELD: "salary" TOINSTANCE: "SQ_details" TOINSTANCETYPE: "Source Qualifier"/>
! <CONNECTOR FROMFIELD: "sno" FROMINSTANCE: "AGG_LOAD" FROMINSTANCETYPE: "Aggregator" TOFIELD: "sno" TOINSTANCE: "TEST_details_tgt" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "sno" FROMINSTANCE: "SQ_details" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "sno" TOINSTANCE: "AGG_LOAD" TOINSTANCETYPE: "Aggregator"/>
! <CONNECTOR FROMFIELD: "sno" FROMINSTANCE: "TEST_details" FROMINSTANCETYPE: "Source Definition" TOFIELD: "sno" TOINSTANCE: "SQ_details" TOINSTANCETYPE: "Source Qualifier"/>
! <CONNECTOR FROMFIELD: "sum_sal" FROMINSTANCE: "AGG_LOAD" FROMINSTANCETYPE: "Aggregator" TOFIELD: "sum_sal" TOINSTANCE: "TEST_details_tgt" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "workexperience" FROMINSTANCE: "AGG_LOAD" FROMINSTANCETYPE: "Aggregator" TOFIELD: "workexperience" TOINSTANCE: "TEST_details_tgt" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "workexperience" FROMINSTANCE: "SQ_details" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "workexperience" TOINSTANCE: "AGG_LOAD" TOINSTANCETYPE: "Aggregator"/>
! <CONNECTOR FROMFIELD: "workexperience" FROMINSTANCE: "TEST_details" FROMINSTANCETYPE: "Source Definition" TOFIELD: "workexperience" TOINSTANCE: "SQ_details" TOINSTANCETYPE: "Source Qualifier"/>
! <INSTANCE DBDNAME: "tduser" DESCRIPTION: "" INSTANCEID: "1" NAME: "TEST_details" TRANSFORMATION_NAME: "TEST_details" TRANSFORMATION_TYPE: "Source Definition" TYPE: "SOURCE"/>
! <INSTANCE DESCRIPTION: "" INSTANCEID: "2" NAME: "SQ_details" REUSABLE: "NO" TRANSFORMATION_NAME: "SQ_details" TRANSFORMATION_TYPE: "Source Qualifier" TYPE: "TRANSFORMATION">
! <ASSOCIATED_SOURCE_INSTANCE NAME: "TEST_details"/>
  </INSTANCE>
! <INSTANCE DESCRIPTION: "" INSTANCEID: "3" NAME: "TEST_details_tgt" TRANSFORMATION_NAME: "TEST_details_tgt" TRANSFORMATION_TYPE: "Target Definition" TYPE: "TARGET"/>
! <INSTANCE DESCRIPTION: "" INSTANCEID: "4" NAME: "AGG_LOAD" REUSABLE: "NO" TRANSFORMATION_NAME: "AGG_LOAD" TRANSFORMATION_TYPE: "Aggregator" TYPE: "TRANSFORMATION"/>
! <TARGETLOADORDER ORDER: "1" TARGETINSTANCE: "TEST_details_tgt"/>
! <TARGETLOADORDER ORDER: "1" TARGETINSTANCE: "TEST_details_tgt"/>
! <TRANSFORMATION DESCRIPTION: "" NAME: "AGG_LOAD" OBJECTVERSION: "1" REUSABLE: "NO" TYPE: "Aggregator" VERSIONNUMBER: "1">
! <TABLEATTRIBUTE NAME: "Aggregator Data Cache Size" VALUE: "Auto"/>
! <TABLEATTRIBUTE NAME: "Aggregator Index Cache Size" VALUE: "Auto"/>
! <TABLEATTRIBUTE NAME: "Cache Directory" VALUE: "$PMCacheDir"/>
! <TABLEATTRIBUTE NAME: "Sorted Input" VALUE: "NO"/>
  <TABLEATTRIBUTE NAME: "Tracing Level" VALUE: "Normal"/>
! <TABLEATTRIBUTE NAME: "Transformation Scope" VALUE: "All Input"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" EXPRESSION: "deptno" EXPRESSIONTYPE: "GROUPBY" NAME: "deptno" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" EXPRESSION: "salary" EXPRESSIONTYPE: "GENERAL" NAME: "salary" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" EXPRESSION: "sno" EXPRESSIONTYPE: "GENERAL" NAME: "sno" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" EXPRESSION: "workexperience" EXPRESSIONTYPE: "GENERAL" NAME: "workexperience" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "string" DEFAULTVALUE: "" DESCRIPTION: "" EXPRESSION: "name" EXPRESSIONTYPE: "GENERAL" NAME: "name" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "20" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "string" DEFAULTVALUE: "ERROR(&apos;transformation error&apos;)" DESCRIPTION: "" EXPRESSION: "sum(salary) " EXPRESSIONTYPE: "GENERAL" NAME: "sum_sal" PICTURETEXT: "" PORTTYPE: "OUTPUT" PRECISION: "10" SCALE: "0"/>
  </TRANSFORMATION>
! <TRANSFORMATION DESCRIPTION: "" NAME: "SQ_details" OBJECTVERSION: "1" REUSABLE: "NO" TYPE: "Source Qualifier" VERSIONNUMBER: "1">
  <TABLEATTRIBUTE NAME: "Is Partitionable" VALUE: "NO"/>
  <TABLEATTRIBUTE NAME: "Number Of Sorted Ports" VALUE: "0"/>
  <TABLEATTRIBUTE NAME: "Output is deterministic" VALUE: "NO"/>
--- 44,80 ----
  <ATTRIBUTE NAME: "Writer Commit Statistics Log Interval" VALUE: "0"/>
  </CONFIG>
  <MAPPING DESCRIPTION: "" ISVALID: "YES" NAME: "m_TEST_DB_FF" OBJECTVERSION: "1" VERSIONNUMBER: "1">
! <CONNECTOR FROMFIELD: "Deptno" FROMINSTANCE: "SQ_employee" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "Deptno" TOINSTANCE: "TEST_TGT_EMP" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "Deptno" FROMINSTANCE: "TEST_EMPLOYEE" FROMINSTANCETYPE: "Source Definition" TOFIELD: "Deptno" TOINSTANCE: "SQ_employee" TOINSTANCETYPE: "Source Qualifier"/>
! <CONNECTOR FROMFIELD: "EmpName" FROMINSTANCE: "SQ_employee" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "Empno" TOINSTANCE: "TEST_TGT_EMP" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "EmpName" FROMINSTANCE: "TEST_EMPLOYEE" FROMINSTANCETYPE: "Source Definition" TOFIELD: "EmpName" TOINSTANCE: "SQ_employee" TOINSTANCETYPE: "Source Qualifier"/>
! <CONNECTOR FROMFIELD: "EmpNo" FROMINSTANCE: "SQ_employee" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "Empname" TOINSTANCE: "TEST_TGT_EMP" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "EmpNo" FROMINSTANCE: "TEST_EMPLOYEE" FROMINSTANCETYPE: "Source Definition" TOFIELD: "EmpNo" TOINSTANCE: "SQ_employee" TOINSTANCETYPE: "Source Qualifier"/>
! <CONNECTOR FROMFIELD: "NEXTVAL" FROMINSTANCE: "SEQ_LOAD" FROMINSTANCETYPE: "Sequence" TOFIELD: "USQN" TOINSTANCE: "TEST_TGT_EMP" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "bonus" FROMINSTANCE: "SQ_employee" FROMINSTANCETYPE: "Source Qualifier" TOFIELD: "bonus" TOINSTANCE: "TEST_TGT_EMP" TOINSTANCETYPE: "Target Definition"/>
! <CONNECTOR FROMFIELD: "bonus" FROMINSTANCE: "TEST_EMPLOYEE" FROMINSTANCETYPE: "Source Definition" TOFIELD: "bonus" TOINSTANCE: "SQ_employee" TOINSTANCETYPE: "Source Qualifier"/>
! <INSTANCE DBDNAME: "tduser" DESCRIPTION: "" INSTANCEID: "1" NAME: "TEST_EMPLOYEE" TRANSFORMATION_NAME: "TEST_EMPLOYEE" TRANSFORMATION_TYPE: "Source Definition" TYPE: "SOURCE"/>
! <INSTANCE DESCRIPTION: "" INSTANCEID: "2" NAME: "SQ_employee" REUSABLE: "NO" TRANSFORMATION_NAME: "SQ_employee" TRANSFORMATION_TYPE: "Source Qualifier" TYPE: "TRANSFORMATION">
! <ASSOCIATED_SOURCE_INSTANCE NAME: "TEST_EMPLOYEE"/>
  </INSTANCE>
! <INSTANCE DESCRIPTION: "" INSTANCEID: "3" NAME: "TEST_TGT_EMP" TRANSFORMATION_NAME: "TEST_TGT_EMP" TRANSFORMATION_TYPE: "Target Definition" TYPE: "TARGET"/>
! <INSTANCE DESCRIPTION: "" INSTANCEID: "4" NAME: "SEQ_LOAD" REUSABLE: "NO" TRANSFORMATION_NAME: "SEQ_LOAD" TRANSFORMATION_TYPE: "Sequence" TYPE: "TRANSFORMATION"/>
! <TARGETLOADORDER ORDER: "1" TARGETINSTANCE: "TEST_TGT_EMP"/>
! <TARGETLOADORDER ORDER: "1" TARGETINSTANCE: "TEST_TGT_EMP"/>
! <TRANSFORMATION DESCRIPTION: "" NAME: "SEQ_LOAD" OBJECTVERSION: "1" REUSABLE: "NO" TYPE: "Sequence" VERSIONNUMBER: "1">
! <TABLEATTRIBUTE NAME: "Current Value" VALUE: "8"/>
! <TABLEATTRIBUTE NAME: "Cycle" VALUE: "NO"/>
! <TABLEATTRIBUTE NAME: "End Value" VALUE: "9223372036854775807"/>
! <TABLEATTRIBUTE NAME: "Increment By" VALUE: "1"/>
! <TABLEATTRIBUTE NAME: "Is Current Value Shared" VALUE: "NO"/>
! <TABLEATTRIBUTE NAME: "Number of Cached Values" VALUE: "0"/>
! <TABLEATTRIBUTE NAME: "Reset" VALUE: "NO"/>
! <TABLEATTRIBUTE NAME: "Start Value" VALUE: "0"/>
  <TABLEATTRIBUTE NAME: "Tracing Level" VALUE: "Normal"/>
! <TRANSFORMFIELD DATATYPE: "bigint" DEFAULTVALUE: "ERROR(&apos;transformation error&apos;)" DESCRIPTION: "" NAME: "CURRVAL" PICTURETEXT: "" PORTTYPE: "OUTPUT" PRECISION: "19" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "bigint" DEFAULTVALUE: "ERROR(&apos;transformation error&apos;)" DESCRIPTION: "" NAME: "NEXTVAL" PICTURETEXT: "" PORTTYPE: "OUTPUT" PRECISION: "19" SCALE: "0"/>
  </TRANSFORMATION>
! <TRANSFORMATION DESCRIPTION: "" NAME: "SQ_employee" OBJECTVERSION: "1" REUSABLE: "NO" TYPE: "Source Qualifier" VERSIONNUMBER: "1">
  <TABLEATTRIBUTE NAME: "Is Partitionable" VALUE: "NO"/>
  <TABLEATTRIBUTE NAME: "Number Of Sorted Ports" VALUE: "0"/>
  <TABLEATTRIBUTE NAME: "Output is deterministic" VALUE: "NO"/>
***************
*** 94,125 ****
  <TABLEATTRIBUTE NAME: "Sql Query" VALUE: ""/>
  <TABLEATTRIBUTE NAME: "Tracing Level" VALUE: "Normal"/>
  <TABLEATTRIBUTE NAME: "User Defined Join" VALUE: ""/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "deptno" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "salary" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "sno" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "workexperience" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "string" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "name" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "20" SCALE: "0"/>
  </TRANSFORMATION>
  </MAPPING>
! <SOURCE BUSINESSNAME: "" DATABASETYPE: "Teradata" DBDNAME: "tduser" DESCRIPTION: "" NAME: "TEST_details" OBJECTVERSION: "1" OWNERNAME: "TEST" VERSIONNUMBER: "1">
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "integer" DESCRIPTION: "" FIELDNUMBER: "1" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "11" LEVEL: "0" NAME: "sno" NULLABLE: "NULL" OCCURS: "0" OFFSET: "0" PHYSICALLENGTH: "10" PHYSICALOFFSET: "0" PICTURETEXT: "" PRECISION: "10" SCALE: "0" USAGE_FLAGS: ""/>
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "integer" DESCRIPTION: "" FIELDNUMBER: "3" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "11" LEVEL: "0" NAME: "deptno" NULLABLE: "NULL" OCCURS: "0" OFFSET: "11" PHYSICALLENGTH: "10" PHYSICALOFFSET: "30" PICTURETEXT: "" PRECISION: "10" SCALE: "0" USAGE_FLAGS: ""/>
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "integer" DESCRIPTION: "" FIELDNUMBER: "4" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "11" LEVEL: "0" NAME: "salary" NULLABLE: "NULL" OCCURS: "0" OFFSET: "22" PHYSICALLENGTH: "10" PHYSICALOFFSET: "40" PICTURETEXT: "" PRECISION: "10" SCALE: "0" USAGE_FLAGS: ""/>
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "integer" DESCRIPTION: "" FIELDNUMBER: "5" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "11" LEVEL: "0" NAME: "workexperience" NULLABLE: "NULL" OCCURS: "0" OFFSET: "33" PHYSICALLENGTH: "10" PHYSICALOFFSET: "50" PICTURETEXT: "" PRECISION: "10" SCALE: "0" USAGE_FLAGS: ""/>
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "varchar" DESCRIPTION: "" FIELDNUMBER: "2" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "0" LEVEL: "0" NAME: "name" NULLABLE: "NULL" OCCURS: "0" OFFSET: "11" PHYSICALLENGTH: "20" PHYSICALOFFSET: "10" PICTURETEXT: "" PRECISION: "20" SCALE: "0" USAGE_FLAGS: ""/>
  </SOURCE>
! <TARGET BUSINESSNAME: "" CONSTRAINT: "" DATABASETYPE: "Flat File" DESCRIPTION: "" NAME: "TEST_details_tgt" OBJECTVERSION: "1" TABLEOPTIONS: "" VERSIONNUMBER: "1">
  <FLATFILE CODEPAGE: "MS1252" CONSECDELIMITERSASONE: "NO" DELIMITED: "YES" DELIMITERS: "," ESCAPE_CHARACTER: "" KEEPESCAPECHAR: "NO" LINESEQUENTIAL: "NO" MULTIDELIMITERSASAND: "NO" NULLCHARTYPE: "ASCII" NULL_CHARACTER: "*" PADBYTES: "1" QUOTE_CHARACTER: "NONE" REPEATABLE: "NO" ROWDELIMITER: "0" SKIPROWS: "0" STRIPTRAILINGBLANKS: "NO"/>
  <TABLEATTRIBUTE NAME: "Datetime Format" VALUE: "A  19 mm/dd/yyyy hh24:mi:ss"/>
  <TABLEATTRIBUTE NAME: "Decimal Separator" VALUE: "."/>
  <TABLEATTRIBUTE NAME: "Line Endings" VALUE: "System default"/>
  <TABLEATTRIBUTE NAME: "Thousand Separator" VALUE: "None"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "int" DESCRIPTION: "" FIELDNUMBER: "1" KEYTYPE: "NOT A KEY" NAME: "sno" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "int" DESCRIPTION: "" FIELDNUMBER: "3" KEYTYPE: "NOT A KEY" NAME: "deptno" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "int" DESCRIPTION: "" FIELDNUMBER: "4" KEYTYPE: "NOT A KEY" NAME: "salary" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "int" DESCRIPTION: "" FIELDNUMBER: "6" KEYTYPE: "NOT A KEY" NAME: "sum_sal" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "nstring" DESCRIPTION: "" FIELDNUMBER: "2" KEYTYPE: "NOT A KEY" NAME: "name" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "number" DESCRIPTION: "" FIELDNUMBER: "5" KEYTYPE: "NOT A KEY" NAME: "workexperience" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
  </TARGET>
  <WORKFLOW DESCRIPTION: "These workflows are created from the Workflow Generation Wizard." ISENABLED: "YES" ISRUNNABLESERVICE: "NO" ISSERVICE: "NO" ISVALID: "YES" NAME: "wf_m_TEST_DB_FF" REUSABLE_SCHEDULER: "NO" SCHEDULERNAME: "Scheduler" SERVERNAME: "ravana" SERVER_DOMAINNAME: "RAWAN" SUSPEND_ON_ERROR: "NO" TASKS_MUST_RUN_ON_SERVER: "NO" VERSIONNUMBER: "1">
  <ATTRIBUTE NAME: "Allow concurrent run with same run instance name" VALUE: "NO"/>
--- 86,114 ----
  <TABLEATTRIBUTE NAME: "Sql Query" VALUE: ""/>
  <TABLEATTRIBUTE NAME: "Tracing Level" VALUE: "Normal"/>
  <TABLEATTRIBUTE NAME: "User Defined Join" VALUE: ""/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "Deptno" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "EmpNo" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "integer" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "bonus" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "10" SCALE: "0"/>
! <TRANSFORMFIELD DATATYPE: "string" DEFAULTVALUE: "" DESCRIPTION: "" NAME: "EmpName" PICTURETEXT: "" PORTTYPE: "INPUT/OUTPUT" PRECISION: "20" SCALE: "0"/>
  </TRANSFORMATION>
  </MAPPING>
! <SOURCE BUSINESSNAME: "" DATABASETYPE: "Teradata" DBDNAME: "tduser" DESCRIPTION: "" NAME: "TEST_EMPLOYEE" OBJECTVERSION: "1" OWNERNAME: "TEST" VERSIONNUMBER: "1">
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "integer" DESCRIPTION: "" FIELDNUMBER: "2" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "11" LEVEL: "0" NAME: "EmpNo" NULLABLE: "NULL" OCCURS: "0" OFFSET: "0" PHYSICALLENGTH: "10" PHYSICALOFFSET: "20" PICTURETEXT: "" PRECISION: "10" SCALE: "0" USAGE_FLAGS: ""/>
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "integer" DESCRIPTION: "" FIELDNUMBER: "3" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "11" LEVEL: "0" NAME: "Deptno" NULLABLE: "NULL" OCCURS: "0" OFFSET: "11" PHYSICALLENGTH: "10" PHYSICALOFFSET: "30" PICTURETEXT: "" PRECISION: "10" SCALE: "0" USAGE_FLAGS: ""/>
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "integer" DESCRIPTION: "" FIELDNUMBER: "4" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "11" LEVEL: "0" NAME: "bonus" NULLABLE: "NULL" OCCURS: "0" OFFSET: "22" PHYSICALLENGTH: "10" PHYSICALOFFSET: "40" PICTURETEXT: "" PRECISION: "10" SCALE: "0" USAGE_FLAGS: ""/>
! <SOURCEFIELD BUSINESSNAME: "" DATATYPE: "varchar" DESCRIPTION: "" FIELDNUMBER: "1" FIELDPROPERTY: "0" FIELDTYPE: "ELEMITEM" HIDDEN: "NO" KEYTYPE: "NOT A KEY" LENGTH: "0" LEVEL: "0" NAME: "EmpName" NULLABLE: "NULL" OCCURS: "0" OFFSET: "0" PHYSICALLENGTH: "20" PHYSICALOFFSET: "0" PICTURETEXT: "" PRECISION: "20" SCALE: "0" USAGE_FLAGS: ""/>
  </SOURCE>
! <TARGET BUSINESSNAME: "" CONSTRAINT: "" DATABASETYPE: "Flat File" DESCRIPTION: "" NAME: "TEST_TGT_EMP" OBJECTVERSION: "1" TABLEOPTIONS: "" VERSIONNUMBER: "1">
  <FLATFILE CODEPAGE: "MS1252" CONSECDELIMITERSASONE: "NO" DELIMITED: "YES" DELIMITERS: "," ESCAPE_CHARACTER: "" KEEPESCAPECHAR: "NO" LINESEQUENTIAL: "NO" MULTIDELIMITERSASAND: "NO" NULLCHARTYPE: "ASCII" NULL_CHARACTER: "*" PADBYTES: "1" QUOTE_CHARACTER: "NONE" REPEATABLE: "NO" ROWDELIMITER: "0" SKIPROWS: "0" STRIPTRAILINGBLANKS: "NO"/>
  <TABLEATTRIBUTE NAME: "Datetime Format" VALUE: "A  19 mm/dd/yyyy hh24:mi:ss"/>
  <TABLEATTRIBUTE NAME: "Decimal Separator" VALUE: "."/>
  <TABLEATTRIBUTE NAME: "Line Endings" VALUE: "System default"/>
  <TABLEATTRIBUTE NAME: "Thousand Separator" VALUE: "None"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "string" DESCRIPTION: "" FIELDNUMBER: "1" KEYTYPE: "NOT A KEY" NAME: "USQN" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "string" DESCRIPTION: "" FIELDNUMBER: "2" KEYTYPE: "NOT A KEY" NAME: "Empno" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "string" DESCRIPTION: "" FIELDNUMBER: "3" KEYTYPE: "NOT A KEY" NAME: "Empname" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "string" DESCRIPTION: "" FIELDNUMBER: "4" KEYTYPE: "NOT A KEY" NAME: "Deptno" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
! <TARGETFIELD BUSINESSNAME: "" DATATYPE: "string" DESCRIPTION: "" FIELDNUMBER: "5" KEYTYPE: "NOT A KEY" NAME: "bonus" NULLABLE: "NULL" PICTURETEXT: "" PRECISION: "10" SCALE: "0"/>
  </TARGET>
  <WORKFLOW DESCRIPTION: "These workflows are created from the Workflow Generation Wizard." ISENABLED: "YES" ISRUNNABLESERVICE: "NO" ISSERVICE: "NO" ISVALID: "YES" NAME: "wf_m_TEST_DB_FF" REUSABLE_SCHEDULER: "NO" SCHEDULERNAME: "Scheduler" SERVERNAME: "ravana" SERVER_DOMAINNAME: "RAWAN" SUSPEND_ON_ERROR: "NO" TASKS_MUST_RUN_ON_SERVER: "NO" VERSIONNUMBER: "1">
  <ATTRIBUTE NAME: "Allow concurrent run with same run instance name" VALUE: "NO"/>
***************
*** 171,206 ****
  <ATTRIBUTE NAME: "Write Backward Compatible Session Log File" VALUE: "NO"/>
  <ATTRIBUTE NAME: "Write performance data to repository" VALUE: "NO"/>
  <CONFIGREFERENCE REFOBJECTNAME: "default_session_config" TYPE: "Session config"/>
! <SESSIONEXTENSION DSQINSTNAME: "SQ_details" DSQINSTTYPE: "Source Qualifier" NAME: "Relational Reader" SINSTANCENAME: "TEST_details" SUBTYPE: "Relational Reader" TRANSFORMATIONTYPE: "Source Definition" TYPE: "READER"/>
! <SESSIONEXTENSION NAME: "File Writer" SINSTANCENAME: "TEST_details_tgt" SUBTYPE: "File Writer" TRANSFORMATIONTYPE: "Target Definition" TYPE: "WRITER">
  <ATTRIBUTE NAME: "Append if Exists" VALUE: "NO"/>
  <ATTRIBUTE NAME: "Codepage Parameter" VALUE: ""/>
  <ATTRIBUTE NAME: "Command" VALUE: ""/>
  <ATTRIBUTE NAME: "Create Target Directory" VALUE: "NO"/>
  <ATTRIBUTE NAME: "Footer Command" VALUE: ""/>
  <ATTRIBUTE NAME: "Header Command" VALUE: ""/>
! <ATTRIBUTE NAME: "Header Options" VALUE: "Output Field Names"/>
  <ATTRIBUTE NAME: "Merge Command" VALUE: ""/>
  <ATTRIBUTE NAME: "Merge File Directory" VALUE: "$PMTargetFileDir&#x5c;"/>
! <ATTRIBUTE NAME: "Merge File Name" VALUE: "details_tgt1.out"/>
  <ATTRIBUTE NAME: "Merge Type" VALUE: "No Merge"/>
  <ATTRIBUTE NAME: "Output Type" VALUE: "File"/>
  <ATTRIBUTE NAME: "Output file directory" VALUE: "$PMTargetFileDir&#x5c;"/>
! <ATTRIBUTE NAME: "Output filename" VALUE: "TEST_details_tgt.out"/>
  <ATTRIBUTE NAME: "Reject file directory" VALUE: "$PMBadFileDir&#x5c;"/>
! <ATTRIBUTE NAME: "Reject filename" VALUE: "TEST_details_tgt.bad"/>
  <CONNECTIONREFERENCE CNXREFNAME: "Connection" CONNECTIONNAME: "" CONNECTIONNUMBER: "1" CONNECTIONSUBTYPE: "" CONNECTIONTYPE: "" VARIABLE: ""/>
  </SESSIONEXTENSION>
! <SESSIONEXTENSION NAME: "Relational Reader" SINSTANCENAME: "SQ_details" SUBTYPE: "Relational Reader" TRANSFORMATIONTYPE: "Source Qualifier" TYPE: "READER">
  <CONNECTIONREFERENCE CNXREFNAME: "DB Connection" CONNECTIONNAME: "Teradata" CONNECTIONNUMBER: "1" CONNECTIONSUBTYPE: "Teradata" CONNECTIONTYPE: "Relational" VARIABLE: ""/>
  </SESSIONEXTENSION>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "NO" PIPELINE: "0" SINSTANCENAME: "TEST_details" STAGE: "0" TRANSFORMATIONNAME: "TEST_details" TRANSFORMATIONTYPE: "Source Definition">
! <ATTRIBUTE NAME: "Owner Name" VALUE: "samples"/>
! <ATTRIBUTE NAME: "Source Table Name" VALUE: "TEST_details"/>
! </SESSTRANSFORMATIONINST>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "YES" PARTITIONTYPE: "HASH AUTO KEYS" PIPELINE: "1" SINSTANCENAME: "AGG_LOAD" STAGE: "3" TRANSFORMATIONNAME: "AGG_LOAD" TRANSFORMATIONTYPE: "Aggregator"/>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "YES" PARTITIONTYPE: "PASS THROUGH" PIPELINE: "1" SINSTANCENAME: "SQ_details" STAGE: "1" TRANSFORMATIONNAME: "SQ_details" TRANSFORMATIONTYPE: "Source Qualifier"/>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "YES" PARTITIONTYPE: "PASS THROUGH" PIPELINE: "1" SINSTANCENAME: "TEST_details_tgt" STAGE: "2" TRANSFORMATIONNAME: "TEST_details_tgt" TRANSFORMATIONTYPE: "Target Definition">
  <FLATFILE CODEPAGE: "MS1252" CONSECDELIMITERSASONE: "NO" DELIMITED: "YES" DELIMITERS: "," ESCAPE_CHARACTER: "" KEEPESCAPECHAR: "NO" LINESEQUENTIAL: "NO" MULTIDELIMITERSASAND: "NO" NULLCHARTYPE: "ASCII" NULL_CHARACTER: "*" PADBYTES: "1" QUOTE_CHARACTER: "NONE" REPEATABLE: "NO" ROWDELIMITER: "0" SKIPROWS: "0" STRIPTRAILINGBLANKS: "NO"/>
  </SESSTRANSFORMATIONINST>
  </SESSION>
--- 160,192 ----
  <ATTRIBUTE NAME: "Write Backward Compatible Session Log File" VALUE: "NO"/>
  <ATTRIBUTE NAME: "Write performance data to repository" VALUE: "NO"/>
  <CONFIGREFERENCE REFOBJECTNAME: "default_session_config" TYPE: "Session config"/>
! <SESSIONEXTENSION DSQINSTNAME: "SQ_employee" DSQINSTTYPE: "Source Qualifier" NAME: "Relational Reader" SINSTANCENAME: "TEST_EMPLOYEE" SUBTYPE: "Relational Reader" TRANSFORMATIONTYPE: "Source Definition" TYPE: "READER"/>
! <SESSIONEXTENSION NAME: "File Writer" SINSTANCENAME: "TEST_TGT_EMP" SUBTYPE: "File Writer" TRANSFORMATIONTYPE: "Target Definition" TYPE: "WRITER">
  <ATTRIBUTE NAME: "Append if Exists" VALUE: "NO"/>
  <ATTRIBUTE NAME: "Codepage Parameter" VALUE: ""/>
  <ATTRIBUTE NAME: "Command" VALUE: ""/>
  <ATTRIBUTE NAME: "Create Target Directory" VALUE: "NO"/>
  <ATTRIBUTE NAME: "Footer Command" VALUE: ""/>
  <ATTRIBUTE NAME: "Header Command" VALUE: ""/>
! <ATTRIBUTE NAME: "Header Options" VALUE: "No Header"/>
  <ATTRIBUTE NAME: "Merge Command" VALUE: ""/>
  <ATTRIBUTE NAME: "Merge File Directory" VALUE: "$PMTargetFileDir&#x5c;"/>
! <ATTRIBUTE NAME: "Merge File Name" VALUE: "tgt_emp1.out"/>
  <ATTRIBUTE NAME: "Merge Type" VALUE: "No Merge"/>
  <ATTRIBUTE NAME: "Output Type" VALUE: "File"/>
  <ATTRIBUTE NAME: "Output file directory" VALUE: "$PMTargetFileDir&#x5c;"/>
! <ATTRIBUTE NAME: "Output filename" VALUE: "TEST_TGT_EMP.out"/>
  <ATTRIBUTE NAME: "Reject file directory" VALUE: "$PMBadFileDir&#x5c;"/>
! <ATTRIBUTE NAME: "Reject filename" VALUE: "TEST_TGT_EMP.bad"/>
  <CONNECTIONREFERENCE CNXREFNAME: "Connection" CONNECTIONNAME: "" CONNECTIONNUMBER: "1" CONNECTIONSUBTYPE: "" CONNECTIONTYPE: "" VARIABLE: ""/>
  </SESSIONEXTENSION>
! <SESSIONEXTENSION NAME: "Relational Reader" SINSTANCENAME: "SQ_employee" SUBTYPE: "Relational Reader" TRANSFORMATIONTYPE: "Source Qualifier" TYPE: "READER">
  <CONNECTIONREFERENCE CNXREFNAME: "DB Connection" CONNECTIONNAME: "Teradata" CONNECTIONNUMBER: "1" CONNECTIONSUBTYPE: "Teradata" CONNECTIONTYPE: "Relational" VARIABLE: ""/>
  </SESSIONEXTENSION>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "NO" PIPELINE: "0" SINSTANCENAME: "SEQ_LOAD" STAGE: "0" TRANSFORMATIONNAME: "SEQ_LOAD" TRANSFORMATIONTYPE: "Sequence"/>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "NO" PIPELINE: "0" SINSTANCENAME: "TEST_EMPLOYEE" STAGE: "0" TRANSFORMATIONNAME: "TEST_EMPLOYEE" TRANSFORMATIONTYPE: "Source Definition"/>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "YES" PARTITIONTYPE: "PASS THROUGH" PIPELINE: "1" SINSTANCENAME: "SQ_employee" STAGE: "1" TRANSFORMATIONNAME: "SQ_employee" TRANSFORMATIONTYPE: "Source Qualifier"/>
! <SESSTRANSFORMATIONINST ISREPARTITIONPOINT: "YES" PARTITIONTYPE: "PASS THROUGH" PIPELINE: "1" SINSTANCENAME: "TEST_TGT_EMP" STAGE: "2" TRANSFORMATIONNAME: "TEST_TGT_EMP" TRANSFORMATIONTYPE: "Target Definition">
  <FLATFILE CODEPAGE: "MS1252" CONSECDELIMITERSASONE: "NO" DELIMITED: "YES" DELIMITERS: "," ESCAPE_CHARACTER: "" KEEPESCAPECHAR: "NO" LINESEQUENTIAL: "NO" MULTIDELIMITERSASAND: "NO" NULLCHARTYPE: "ASCII" NULL_CHARACTER: "*" PADBYTES: "1" QUOTE_CHARACTER: "NONE" REPEATABLE: "NO" ROWDELIMITER: "0" SKIPROWS: "0" STRIPTRAILINGBLANKS: "NO"/>
  </SESSTRANSFORMATIONINST>
  </SESSION>