![]() | Job Documentation |
Generated by Talend Open Studio |
PROJECT NAME | London | GENERATION DATE | 24-mar-2010 1:09:21 |
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 | Inicializa_Tablas_Hechos |
Author | respinosa@terramiticapark.com |
Version | 0.1 |
Purpose | |
Status | |
Description | |
Creation | 23-mar-2010 21:07:11 |
Modification | 24-mar-2010 0:08:52 |
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 |
---|---|
tFlowToIterate_1 | tFlowToIterate |
tLogRow_1 | tLogRow |
tLogRow_2 | tLogRow |
tMap_1 | tMap |
tMysqlInput_1 | tMysqlInput |
tMysqlInput_2 | tMysqlInput |
tMysqlOutput_1 | tMysqlOutput |
tMysqlOutput_2 | tMysqlOutput |
tMysqlOutput_3 | tMysqlOutput |
tMysqlOutput_4 | tMysqlOutput |
tMysqlOutput_5 | tMysqlOutput |
tMysqlOutput_6 | tMysqlOutput |
tReplicate_1 | tReplicate |
Component: tFlowToIterate |
![]() | UNIQUE NAME | tFlowToIterate_1 | INPUT(S) | tLogRow_1 |
LABEL | __UNIQUE_NAME__ | OUTPUT(S) | tMysqlInput_1 |
Properties | Values |
---|---|
Activate | true |
tStatCatcher Statistics | false |
Use the default (key, value) in global variables. | true |
Show Information | false |
Comentario |
Column | Key | Type | Length | Precision | Nullable | Comment |
---|
Component: tLogRow |
![]() | UNIQUE NAME | tLogRow_1 | INPUT(S) | tMysqlInput_2 |
LABEL | visualiza_registro | OUTPUT(S) | tFlowToIterate_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 |
---|---|---|---|---|---|---|
Anyo_id | true | int | 10 | false | ||
Anyo_desc | false | String | 25 | false | ||
Siglo_id | false | short | 5 | false | ||
Siglo_desc | false | String | 45 | false | ||
Decada_id | false | short | 5 | false | ||
Decada_desc | false | String | 45 | false |
Component: tLogRow |
![]() | UNIQUE NAME | tLogRow_2 | INPUT(S) | tMap_1 |
LABEL | __UNIQUE_NAME__ | OUTPUT(S) | tReplicate_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 | ||
Anyo_id | true | Integer | true |
Component: tMysqlInput |
![]() | UNIQUE NAME | tMysqlInput_1 | INPUT(S) | tFlowToIterate_1 |
LABEL | leo_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 | "dwd_area" |
Guess Schema | "" |
Query | "SELECT dwd_area.area_id, dwd_area.area_desc, dwd_area.zona_id, dwd_area.zona_desc, dwd_area.mapa FROM dwd_area" |
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=Zona_id, TRIM=false}, {SCHEMA_COLUMN=Zona_desc, TRIM=false}, {SCHEMA_COLUMN=Mapa, 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 | ||
Zona_id | false | short | 5 | false | ||
Zona_desc | false | String | 45 | true | ||
Mapa | false | String | 45 | true |
Component: tMysqlInput |
![]() | UNIQUE NAME | tMysqlInput_2 | INPUT(S) | none |
LABEL | leo_años | OUTPUT(S) | tLogRow_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 | "dwd_tiempo" |
Guess Schema | "" |
Query | "SELECT dwd_tiempo.anyo_id, dwd_tiempo.anyo_desc, dwd_tiempo.siglo_id, dwd_tiempo.siglo_desc, dwd_tiempo.decada_id, dwd_tiempo.decada_desc FROM dwd_tiempo" |
Additional JDBC Parameters | "noDatetimeStringSync=true" |
Codificación | "ISO-8859-15" |
Enable stream | false |
Trim all the String/Char columns | false |
Trim column | [{SCHEMA_COLUMN=Anyo_id, TRIM=false}, {SCHEMA_COLUMN=Anyo_desc, TRIM=false}, {SCHEMA_COLUMN=Siglo_id, TRIM=false}, {SCHEMA_COLUMN=Siglo_desc, TRIM=false}, {SCHEMA_COLUMN=Decada_id, TRIM=false}, {SCHEMA_COLUMN=Decada_desc, TRIM=false}] |
Show Information | false |
Comentario |
Column | Key | Type | Length | Precision | Nullable | Comment |
---|---|---|---|---|---|---|
Anyo_id | true | int | 10 | false | ||
Anyo_desc | false | String | 25 | false | ||
Siglo_id | false | short | 5 | false | ||
Siglo_desc | false | String | 45 | false | ||
Decada_id | false | short | 5 | false | ||
Decada_desc | false | String | 45 | false |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_1 | INPUT(S) | tReplicate_1 |
LABEL | __TABLE__ | 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 | "dwh_auto" |
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 | ||
Anyo_id | true | Integer | true |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_2 | INPUT(S) | tReplicate_1 |
LABEL | __TABLE__ | 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 | "dwh_economia" |
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 | ||
Anyo_id | true | Integer | true |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_3 | INPUT(S) | tReplicate_1 |
LABEL | __TABLE__ | 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 | "dwh_cultura" |
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 | ||
Anyo_id | true | Integer | true |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_4 | INPUT(S) | tReplicate_1 |
LABEL | __TABLE__ | 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 | "dwh_poblacion" |
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 | ||
Anyo_id | true | Integer | true |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_5 | INPUT(S) | tReplicate_1 |
LABEL | __TABLE__ | 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 | "dwh_salud" |
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 | ||
Anyo_id | true | Integer | true |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_6 | INPUT(S) | tReplicate_1 |
LABEL | __TABLE__ | 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 | "dwh_viviendas" |
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 | ||
Anyo_id | true | Integer | true |
Component: tReplicate |
![]() | UNIQUE NAME | tReplicate_1 | INPUT(S) | tLogRow_2 |
LABEL | __UNIQUE_NAME__ | OUTPUT(S) | tMysqlOutput_1, tMysqlOutput_6, tMysqlOutput_3, tMysqlOutput_2, tMysqlOutput_4, tMysqlOutput_5 |
Properties | Values |
---|---|
Activate | true |
tStatCatcher Statistics | false |
Show Information | false |
Comentario |
Column | Key | Type | Length | Precision | Nullable | Comment |
---|---|---|---|---|---|---|
Area_id | true | String | 4 | false | ||
Anyo_id | true | Integer | true |
Component: tMap |
![]() | UNIQUE NAME | tMap_1 | INPUT(S) | tMysqlInput_1 |
LABEL | __UNIQUE_NAME__ | OUTPUT(S) | tLogRow_2 |
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(
row2
):
Metadata Table Entries( row2 ):
Constraint Table Entries( row2 ):
|
Mapper table Properties(
salida
):
Metadata Table Entries( salida ):
Constraint Table Entries( salida ):
|
Mapper table Properties(
Var
):
Metadata Table Entries( Var ):
Constraint Table Entries( Var ):
|