Generated documentation

	Jobs
	Generated by Talend Open Studio for Big Data

Project Name	RECON_TEST	GENERATION DATE	11 Aug, 2017 5:45:34 PM
AUTHOR	user@talend.com	Talend Open Studio VERSION	6.3.0.20161026_1219

Summary

Project Description

Description

Preview Picture

Settings

Context List

Component List

Components Description

Project Description

Properties	Values
Name	RECON_TEST
Language	java
Description

Description

Properties	Values
Name	Mutiple_Folder
Author	user@talend.com
Version	0.1
Purpose
Status
Description
Creation	9 Aug, 2017 8:15:55 PM
Modification	11 Aug, 2017 5:44:56 PM

Preview Picture

Settings

Extra settings

Name	Value
COMP_DEFAULT_FILE_DIR
Multi thread execution	false
Implicit tContextLoad	false

Status & Logs

Name	Value
Use statistics (tStatCatcher)	false
Use logs (tLogCatcher)	false
Use volumetrics (tFlowMeterCatcher)	false
On Console	false
On Files	false
On Databases	false
Catch components statistics	false
Catch runtime errors	true
Catch user errors	true
Catch user warnings	true

Context List

ContextDefault

Name	Prompt	Need Prompt?	Type	Value	Source

Component List

Component Name	Component Type
tFileOutputExcel_1	tFileOutputExcel
tFlowToIterate_1	tFlowToIterate
tMap_1	tMap
tOracleInput_1	tOracleInput
tOracleInput_2	tOracleInput

Components Description

Component tFileOutputExcel

	UNIQUE NAME	tFileOutputExcel_1	INPUT(S)	tOracleInput_2
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	none

Component Parameters:

Properties	Values
Unique Name	tFileOutputExcel_1
Component Name	tFileOutputExcel
Version	0.101 (ALPHA)
Family	File/Output
Startable	false
SUBTREE_START	false
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tFileOutputExcel
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	F:\Talend\Software\TOS_BD-20161026_1219-V6.3.0\TOS_BD-20161026_1219-V6.3.0\configuration\lib\java
Subjob color
Title color
Property Type	Built-In
Write excel2007 file format(xlsx)	true
Use Output Stream	false
Output Stream	outputStream
File Name	"C:/Users/DELL PC/Desktop/C/a/out.xlsx"+((Integer)globalMap.get("tFlowToIterate_1_CURRENT_ITERATION"))
Sheet name	"Sheet1"
Include header	true
Append existing file	false
Append existing sheet	false
Is absolute Y pos.	false
First cell X	0
First cell Y	0
Keep existing cell format	false
Font
Define all columns auto size	true
Define column auto size	[{IS_AUTO_SIZE=false, SCHEMA_COLUMN=TRN_REF_NO}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=TXN_DT}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=VAL_DT}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=TXN_INIT_DATE}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=TXN_CCY}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=FCY_AMT}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=LCY_AMT}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=FLAG}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=LINK_ID}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=BATCH_NO}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=TXN_BRANCH_CODE}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=RELATED_ACC}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=DRCR_IND}, {IS_AUTO_SIZE=false, SCHEMA_COLUMN=EVENT}]
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
Create directory if does not exist	true
Custom the flush buffer size	false
Row number	100
Advanced separator (for numbers)	false
Thousands separator	","
Decimal separator	"."
Encoding	"ISO-8859-15"
Don't generate empty file	false
Recalculate formula	false
!!!SCHEMA_OPT_NUM.NAME!!!	100
Label format	__UNIQUE_NAME__
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for REC_TAB_MTN_CBANK :

Column	Key	Type	Length	Precision	Nullable
TRN_REF_NO	true	String	30		false
TXN_DT	false	java.util.Date	7		true
VAL_DT	false	java.util.Date	7		true
TXN_INIT_DATE	false	java.util.Date	7		true
TXN_CCY	false	String	3		true
FCY_AMT	false	BigDecimal	22	4	true
LCY_AMT	false	BigDecimal	22	4	true
FLAG	false	String	30		true
LINK_ID	false	String	50		true
BATCH_NO	false	String	50		true
TXN_BRANCH_CODE	false	String	50		true
RELATED_ACC	false	String	50		true
DRCR_IND	false	String	50		true
EVENT	false	String	5		true

Original Function Parameters:

Component tFlowToIterate

	UNIQUE NAME	tFlowToIterate_1	INPUT(S)	tMap_1
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	tOracleInput_2

Component Parameters:

Properties	Values
Unique Name	tFlowToIterate_1
Component Name	tFlowToIterate
Version	0.101 (ALPHA)
Family	Orchestration
Startable	false
SUBTREE_START	false
END_OF_FLOW	true
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tFlowToIterate
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	F:\Talend\Software\TOS_BD-20161026_1219-V6.3.0\TOS_BD-20161026_1219-V6.3.0\configuration\lib\java
Subjob color
Title color
Use the default (key, value) in global variables.	true
Customize	[]
Schema	Built-In
Label format	__UNIQUE_NAME__
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tFlowToIterate_1 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component tOracleInput

	UNIQUE NAME	tOracleInput_1	INPUT(S)	none
	LABEL	__TABLE__	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Unique Name	tOracleInput_1
Component Name	tOracleInput
Version	0.102 (ALPHA)
Family	Databases/Oracle
Start	true
Startable	true
SUBTREE_START	true
END_OF_FLOW	false
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tOracleInput
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	F:\Talend\Software\TOS_BD-20161026_1219-V6.3.0\TOS_BD-20161026_1219-V6.3.0\configuration\lib\java
Subjob color
Title color
Property Type	repository: DB (ORACLE_SID):RECN_UAT_ORACLE
Use an existing connection	false
Component List
Connection Type	ORACLE_SID
DB Version	ORACLE_12
URL	"localhost"
Host	"localhost"
Database Driver	ORACLE_SID
Port	"1521"
Database	"orcl"
Local Service Name	"orcl"
Oracle schema	""
Username	"RECON_UAT"
Password	***********
URL	"jdbc:oracle:oci:/@talend"
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
Table Name	"REC_TAB_MTN_CBANK"
Query Type	Built-In
Guess Schema	""
Query	"select distinct txn_dt from REC_TAB_MTN_CBANK"
Specify a data source alias	false
Data source alias	""
Mapping	oracle_id
Additional JDBC Parameters	"allowMultiQueries=true"
Convert XMLType To Java Type.(just when use extract() return a NODE)	false
	[]
Encoding	"ISO-8859-15"
Use cursor	false
Cursor size	1000
Trim all the String/Char columns	false
Trim column	[{TRIM=false, SCHEMA_COLUMN=TXN_DT}]
No null values	false
Label format	__TABLE__
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for tOracleInput_1 :

Column	Key	Type	Length	Precision	Nullable	Comment
TXN_DT	false	java.util.Date			true

Original Function Parameters:

Component tOracleInput

	UNIQUE NAME	tOracleInput_2	INPUT(S)	tFlowToIterate_1
	LABEL	__TABLE__	OUTPUT(S)	tFileOutputExcel_1

Component Parameters:

Properties	Values
Unique Name	tOracleInput_2
Component Name	tOracleInput
Version	0.102 (ALPHA)
Family	Databases/Oracle
Start	false
Startable	true
SUBTREE_START	false
END_OF_FLOW	false
Activate	true
DUMMY	false
tStatCatcher Statistics	false
Help	org.talend.help.tOracleInput
Update components	true
IREPORT_PATH
JAVA_LIBRARY_PATH	F:\Talend\Software\TOS_BD-20161026_1219-V6.3.0\TOS_BD-20161026_1219-V6.3.0\configuration\lib\java
Subjob color
Title color
Property Type	repository: DB (ORACLE_SID):RECN_UAT_ORACLE
Use an existing connection	false
Component List
Connection Type	ORACLE_SID
DB Version	ORACLE_12
URL	"localhost"
Host	"localhost"
Database Driver	ORACLE_SID
Port	"1521"
Database	"orcl"
Local Service Name	"orcl"
Oracle schema	""
Username	"RECON_UAT"
Password	***********
URL	"jdbc:oracle:oci:/@talend"
REPOSITORY_ALLOW_AUTO_SWITCH	true
Schema	Built-In
Table Name	"REC_TAB_MTN_CBANK"
Query Type	Built-In
Guess Schema	""
Query	"SELECT RECON_UAT.REC_TAB_MTN_CBANK.TRN_REF_NO, RECON_UAT.REC_TAB_MTN_CBANK.TXN_DT, RECON_UAT.REC_TAB_MTN_CBANK.VAL_DT, RECON_UAT.REC_TAB_MTN_CBANK.TXN_INIT_DATE, RECON_UAT.REC_TAB_MTN_CBANK.TXN_CCY, RECON_UAT.REC_TAB_MTN_CBANK.FCY_AMT, RECON_UAT.REC_TAB_MTN_CBANK.LCY_AMT, RECON_UAT.REC_TAB_MTN_CBANK.FLAG, RECON_UAT.REC_TAB_MTN_CBANK.LINK_ID, RECON_UAT.REC_TAB_MTN_CBANK.BATCH_NO, RECON_UAT.REC_TAB_MTN_CBANK.TXN_BRANCH_CODE, RECON_UAT.REC_TAB_MTN_CBANK.RELATED_ACC, RECON_UAT.REC_TAB_MTN_CBANK.DRCR_IND, RECON_UAT.REC_TAB_MTN_CBANK.EVENT FROM RECON_UAT.REC_TAB_MTN_CBANK"
Specify a data source alias	false
Data source alias	""
Mapping	oracle_id
Additional JDBC Parameters	"allowMultiQueries=true"
Convert XMLType To Java Type.(just when use extract() return a NODE)	false
	[]
Encoding	"ISO-8859-15"
Use cursor	false
Cursor size	1000
Trim all the String/Char columns	false
Trim column	[{TRIM=false, SCHEMA_COLUMN=TRN_REF_NO}, {TRIM=false, SCHEMA_COLUMN=TXN_DT}, {TRIM=false, SCHEMA_COLUMN=VAL_DT}, {TRIM=false, SCHEMA_COLUMN=TXN_INIT_DATE}, {TRIM=false, SCHEMA_COLUMN=TXN_CCY}, {TRIM=false, SCHEMA_COLUMN=FCY_AMT}, {TRIM=false, SCHEMA_COLUMN=LCY_AMT}, {TRIM=false, SCHEMA_COLUMN=FLAG}, {TRIM=false, SCHEMA_COLUMN=LINK_ID}, {TRIM=false, SCHEMA_COLUMN=BATCH_NO}, {TRIM=false, SCHEMA_COLUMN=TXN_BRANCH_CODE}, {TRIM=false, SCHEMA_COLUMN=RELATED_ACC}, {TRIM=false, SCHEMA_COLUMN=DRCR_IND}, {TRIM=false, SCHEMA_COLUMN=EVENT}]
No null values	false
Label format	__TABLE__
Hint format	<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection format	row
Show Information	false
Comment
Use an existing validation rule	false
Validation Rule Type

Schema for REC_TAB_MTN_CBANK :

Column	Key	Type	Length	Precision	Nullable
TRN_REF_NO	true	String	30		false
TXN_DT	false	java.util.Date	7		true
VAL_DT	false	java.util.Date	7		true
TXN_INIT_DATE	false	java.util.Date	7		true
TXN_CCY	false	String	3		true
FCY_AMT	false	BigDecimal	22	4	true
LCY_AMT	false	BigDecimal	22	4	true
FLAG	false	String	30		true
LINK_ID	false	String	50		true
BATCH_NO	false	String	50		true
TXN_BRANCH_CODE	false	String	50		true
RELATED_ACC	false	String	50		true
DRCR_IND	false	String	50		true
EVENT	false	String	5		true

Original Function Parameters:

Component tMap

	UNIQUE NAME	tMap_1	INPUT(S)	tOracleInput_1
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	tFlowToIterate_1

Component Parameters:

Properties	Values
tStatCatcher Statistics	false
Mapping links display as:	AUTO
Temp data directory path:
Max buffer size (nb of rows):	2000000
Ignore trailing zeros for BigDecimal	false
Show Information	false
Comment
Use an existing validation rule	false

Mapper table for tMap_1 ( input ):

Mapper table Properties( row2 ):

Properties	Values
Name	row2
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false
expressionFilter	null

Metadata Table Entries( row2 ):

Name	Type	Expression	isNullable
TXN_DT	java.util.Date		true

Constraint Table Entries( row2 ):

Name	Type	Expression	isNullable

Mapper table for tMap_1 ( output ):

Mapper table Properties( r ):

Properties	Values
Name	r
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false
expressionFilter	null

Metadata Table Entries( r ):

Name	Type	Expression	isNullable
TXN_DT	java.util.Date	row2.TXN_DT	true

Constraint Table Entries( r ):

Name	Type	Expression	isNullable

Mapper table for tMap_1 ( var ):

Mapper table Properties( Var ):

Properties	Values
Name	Var
Matching-mode
isMinimized	true
isReject	false
isRejectInnerJoin	false
isInnerJoin	false
expressionFilter	null

Metadata Table Entries( Var ):

Name	Type	Expression	isNullable

Constraint Table Entries( Var ):

Name	Type	Expression	isNullable