| Jobs |
| Generated by Talend Open Studio for Big Data |
| Project Name | RECON_TEST | GENERATION DATE | 11 Aug, 2017 5:41:34 PM |
| AUTHOR | user@talend.com | Talend Open Studio VERSION | 6.3.0.20161026_1219 |
| Properties | Values |
|---|---|
| Name | RECON_TEST |
| Language | java |
| 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:35:00 PM |
| 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 |
| ContextDefault |
| Name | Prompt | Need Prompt? | Type | Value | Source |
|---|
| Component Name | Component Type |
|---|---|
| tFileTouch_1 | tFileTouch |
| tFlowToIterate_1 | tFlowToIterate |
| tMap_1 | tMap |
| tOracleInput_1 | tOracleInput |
| Component tFileTouch |
 | UNIQUE NAME | tFileTouch_1 | INPUT(S) | tFlowToIterate_1 |
| LABEL | __UNIQUE_NAME__ | OUTPUT(S) | none |
| Properties | Values |
|---|---|
| Unique Name | tFileTouch_1 |
| Component Name | tFileTouch |
| Version | 0.102 (ALPHA) |
| Family | File/Management |
| Start | false |
| Startable | true |
| SUBTREE_START | false |
| END_OF_FLOW | true |
| Activate | true |
| DUMMY | false |
| tStatCatcher Statistics | false |
| Help | org.talend.help.tFileTouch |
| 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 | |
| File Name | "C:/Users/DELL PC/Desktop/C/a/out11.csv" |
| Create directory if does not exist | true |
| 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 |
| Column | Key | Type | Length | Precision | Nullable | Comment |
|---|
| Component tFlowToIterate |
 | UNIQUE NAME | tFlowToIterate_1 | INPUT(S) | tMap_1 |
| LABEL | __UNIQUE_NAME__ | OUTPUT(S) | tFileTouch_1 |
| 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 |
| Column | Key | Type | Length | Precision | Nullable | Comment |
|---|
| Component tOracleInput |
 | UNIQUE NAME | tOracleInput_1 | INPUT(S) | none |
| LABEL | __TABLE__ | OUTPUT(S) | tMap_1 |
| 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 |
| Column | Key | Type | Length | Precision | Nullable | Comment |
|---|---|---|---|---|---|---|
| TXN_DT | false | java.util.Date | true |
| Component tMap |
 | UNIQUE NAME | tMap_1 | INPUT(S) | tOracleInput_1 |
| LABEL | __UNIQUE_NAME__ | OUTPUT(S) | tFlowToIterate_1 |
| 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 Properties(
row2
):
Metadata Table Entries( row2 ):
Constraint Table Entries( row2 ):
|
Mapper table Properties(
r
):
Metadata Table Entries( r ):
Constraint Table Entries( r ):
|
Mapper table Properties(
Var
):
Metadata Table Entries( Var ):
Constraint Table Entries( Var ):
|