![]() | Job Documentation |
Generated by Talend Open Studio |
PROJECT NAME | London | GENERATION DATE | 24-mar-2010 1:09:27 |
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_Tiempo |
Author | respinosa@terramiticapark.com |
Version | 0.1 |
Purpose | |
Status | |
Description | |
Creation | 23-mar-2010 21:07:11 |
Modification | 24-mar-2010 0:08:46 |
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) | tMysqlInput_1 |
LABEL | visualiza_registro | OUTPUT(S) | tMap_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 | true | String | 4 | false |
Component: tMysqlInput |
![]() | UNIQUE NAME | tMysqlInput_1 | INPUT(S) | none |
LABEL | leer_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 | "ds_estadisticas" |
Guess Schema | "" |
Query | "SELECT distinct ds_estadisticas.Anyo FROM ds_estadisticas order by Anyo" |
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, TRIM=false}] |
Show Information | false |
Comentario |
Column | Key | Type | Length | Precision | Nullable | Comment |
---|---|---|---|---|---|---|
Anyo | true | String | 4 | false |
Component: tMysqlOutput |
![]() | UNIQUE NAME | tMysqlOutput_1 | INPUT(S) | tMap_1 |
LABEL | llena dwd_tiempo | 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_tiempo" |
Action on table | NONE |
Action on data | UPDATE_OR_INSERT |
Schema | |
Die on error | false |
Additional JDBC Parameters | "noDatetimeStringSync=true" |
Codificación | "ISO-8859-15" |
Commit every | 10000 |
Columnas adicionales | [] |
Use field options | false |
Use Hint Options | false |
Enable debug mode | 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: tMap |
![]() | UNIQUE NAME | tMap_1 | INPUT(S) | tLogRow_1 |
LABEL | mapea_anyo | OUTPUT(S) | tMysqlOutput_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(
row2
):
Metadata Table Entries( row2 ):
Constraint Table Entries( row2 ):
|
Mapper table Properties(
anyos
):
Metadata Table Entries( anyos ):
Constraint Table Entries( anyos ):
|
Mapper table Properties(
Var
):
Metadata Table Entries( Var ):
Constraint Table Entries( Var ):
|