![]() | Job Documentation |
Generated by Talend Open Studio |
PROJECT NAME | London | GENERATION DATE | 24-mar-2010 1:09:25 |
AUTHOR | respinosa@terramiticapark.com | T.O.S VERSION | 4.0.0.M1_r33789 |
Properties | Values |
---|---|
Name | London |
Language | java |
Description | Proyecto BI de Analisis de Datos Públicos |
Properties | Values |
---|---|
Name | Llena_Dimension_Geografica |
Author | respinosa@terramiticapark.com |
Version | 0.1 |
Purpose | |
Status | |
Description | |
Creation | 23-mar-2010 21:59:49 |
Modification | 23-mar-2010 23:59:03 |
Extra settings |
Name | Value |
---|---|
COMP_DEFAULT_FILE_DIR | C:/Talend/TOS-Win32-r33789-V4.0.0M1/workspace |
Multi thread execution | false |
Implicit tContextLoad | false |
Stats & 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 : Default |
Name | Prompt | Need Prompt? | Type | Value | Source |
---|
Component Name | Component Type |
---|---|
tLogRow_1 | tLogRow |
tMap_1 | tMap |
tMysqlInput_1 | tMysqlInput |
tMysqlOutput_1 | tMysqlOutput |
Component: tLogRow |
![]() | UNIQUE NAME | tLogRow_1 | INPUT(S) | tMap_1 |
LABEL | __UNIQUE_NAME__ | OUTPUT(S) | tMysqlOutput_1 |
Properties | Values |
---|---|
Activate | true |
tStatCatcher Statistics | false |
Basic | true |
Table (print values in cells of a table) | false |
Vertical (each row is a key/value list) | false |
Field Separator | "|" |
Print header | false |
Print component unique name in front of each output row | false |
Print schema column name in front of each value | false |
Use fixed length for values | false |
Show Information | false |
Comentario |
Column | Key | Type | Length | Precision | Nullable | Comment |
---|---|---|---|---|---|---|
area_id | true | String | 4 | false | ||
area_desc | false | String | 25 | false | ||
zona_id | false | Short | 5 | true | ||
zona_desc | false | String | 45 | true | ||
mapa | false | String | 45 | true |
Component: tMysqlInput |
![]() | UNIQUE NAME | tMysqlInput_1 | INPUT(S) | none |
LABEL | lee_areas | OUTPUT(S) | tMap_1 |
Properties | Values |
---|---|
Activate | true |
tStatCatcher Statistics | false |
Use an existing connection | false |
Host | "pcserver7" |
Port | "3306" |
Base de Datos | "london" |
Username | "root" |
Password | ****** |
Table Name | "ds_area" |
Guess Schema | "" |
Query | "SELECT ds_area.Area_id, ds_area.Area_desc, ds_area.Circunscripcion FROM ds_area order by Area_id" |
Additional JDBC Parameters | "noDatetimeStringSync=true" |
Codificación | "ISO-8859-15" |
Enable stream | false |
Trim all the String/Char columns | false |
Trim column | [{SCHEMA_COLUMN=Area_id, TRIM=false}, {SCHEMA_COLUMN=Area_desc, TRIM=false}, {SCHEMA_COLUMN=Circunscripcion, TRIM=false}] |
Show Information | false |
Comentario |
Column | Key | Type | Length | Precision | Nullable | Comment |
---|---|---|---|---|---|---|
Area_id | true | String | 4 | false | ||
Area_desc | false | String | 25 | false | ||
Circunscripcion | false | String | 22 | true |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_1 | INPUT(S) | tLogRow_1 |
LABEL | llena dwd_area | OUTPUT(S) | none |
Properties | Values |
---|---|
Activate | true |
tStatCatcher Statistics | false |
Use an existing connection | false |
Host | "pcserver7" |
Port | "3306" |
Base de Datos | "london" |
Username | "root" |
Password | ****** |
Table | "dwd_area" |
Action on table | NONE |
Action on data | INSERT |
Schema | |
Die on error | false |
Additional JDBC Parameters | "noDatetimeStringSync=true" |
Extend Insert | true |
Note | (Not compatible with reject links) |
Number of rows per insert | 100 |
Codificación | "ISO-8859-15" |
Commit every | 10000 |
Columnas adicionales | [] |
Use field options | false |
Use Hint Options | false |
Enable debug mode | false |
Use duplicate key update mode insert | false |
Show Information | false |
Comentario |
Column | Key | Type | Length | Precision | Nullable | Comment |
---|---|---|---|---|---|---|
Area_id | true | String | 4 | false | ||
Area_desc | false | String | 25 | false | ||
Zona_id | false | short | 5 | false | ||
Zona_desc | false | String | 45 | true | ||
Mapa | false | String | 45 | true |
Component: tMap |
![]() | UNIQUE NAME | tMap_1 | INPUT(S) | tMysqlInput_1 |
LABEL | mapea_areas | OUTPUT(S) | tLogRow_1 |
Properties | Values |
---|---|
tStatCatcher Statistics | false |
Mapping links display as: | AUTO |
Temp data directory path: | |
Max buffer size (nb of rows): | 2000000 |
Show Information | false |
Comentario |
Mapper table Properties(
row1
):
Metadata Table Entries( row1 ):
Constraint Table Entries( row1 ):
|
Mapper table Properties(
registros_area
):
Metadata Table Entries( registros_area ):
Constraint Table Entries( registros_area ):
|
Mapper table Properties(
Var
):
Metadata Table Entries( Var ):
Constraint Table Entries( Var ):
|