unified.txt

--- data/V1.XML
+++ data/V2.XML
@@ -1,3 +1,3 @@
 <root>
-<POWERMART CREATION_DATE: "06/01/2018 13:55:55" REPOSITORY_VERSION: "181.90">
+<POWERMART CREATION_DATE: "06/06/2018 13:21:13" REPOSITORY_VERSION: "181.90">
 <REPOSITORY NAME: "Support" VERSION: "181" CODEPAGE: "MS1252" DATABASETYPE: "Microsoft SQL Server">
@@ -46,41 +46,33 @@
 <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"/>
+<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_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"/>
+<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"/>
-<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"/>
+<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_details" OBJECTVERSION: "1" REUSABLE: "NO" TYPE: "Source Qualifier" VERSIONNUMBER: "1">
+<TRANSFORMATION DESCRIPTION: "" NAME: "SQ_employee" OBJECTVERSION: "1" REUSABLE: "NO" TYPE: "Source Qualifier" VERSIONNUMBER: "1">
 <TABLEATTRIBUTE NAME: "Is Partitionable" VALUE: "NO"/>
@@ -96,17 +88,15 @@
 <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"/>
+<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_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 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_details_tgt" OBJECTVERSION: "1" TABLEOPTIONS: "" VERSIONNUMBER: "1">
+<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"/>
@@ -116,8 +106,7 @@
 <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"/>
+<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>
@@ -173,4 +162,4 @@
 <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">
+<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"/>
@@ -181,6 +170,6 @@
 <ATTRIBUTE NAME: "Header Command" VALUE: ""/>
-<ATTRIBUTE NAME: "Header Options" VALUE: "Output Field Names"/>
+<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: "details_tgt1.out"/>
+<ATTRIBUTE NAME: "Merge File Name" VALUE: "tgt_emp1.out"/>
 <ATTRIBUTE NAME: "Merge Type" VALUE: "No Merge"/>
@@ -188,17 +177,14 @@
 <ATTRIBUTE NAME: "Output file directory" VALUE: "$PMTargetFileDir&#x5c;"/>
-<ATTRIBUTE NAME: "Output filename" VALUE: "TEST_details_tgt.out"/>
+<ATTRIBUTE NAME: "Output filename" VALUE: "TEST_TGT_EMP.out"/>
 <ATTRIBUTE NAME: "Reject file directory" VALUE: "$PMBadFileDir&#x5c;"/>
-<ATTRIBUTE NAME: "Reject filename" VALUE: "TEST_details_tgt.bad"/>
+<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_details" SUBTYPE: "Relational Reader" TRANSFORMATIONTYPE: "Source Qualifier" TYPE: "READER">
+<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: "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">
+<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"/>