Job Documentation
Generated by Talend Open Studio


PROJECT NAME London GENERATION DATE 24-mar-2010 1:09:30
AUTHOR respinosa@terramiticapark.comT.O.S VERSION 4.0.0.M1_r33789

Summary

Project Description
Job Description
Job Preview Picture
Job Settings
Context List
Component List
Components Description


Project Description


Properties Values
NameLondon
Languagejava
Description
Proyecto BI de Analisis de Datos Públicos


Job Description


Properties Values
NameProcesa_estadisticas
Authorrespinosa@terramiticapark.com
Version0.1
Purpose
Status
Description
Creation24-mar-2010 0:01:39
Modification 24-mar-2010 1:09:21

Job Preview Picture


No image available
tLogRow_1tLogRow_2tLogRow_3tLogRow_4tLogRow_5tLogRow_6tMap_1tMysqlInput_1tMysqlRow_1tMysqlRow_2tMysqlRow_3tMysqlRow_4tMysqlRow_5tMysqlRow_6

Job settings

Extra settings

Name Value
COMP_DEFAULT_FILE_DIRC:/Talend/TOS-Win32-r33789-V4.0.0M1/workspace
Multi thread executionfalse
Implicit tContextLoadfalse


Stats & Logs

Name Value
Use statistics (tStatCatcher)false
Use logs (tLogCatcher)false
Use volumetrics (tFlowMeterCatcher)false
On Consolefalse
On Filesfalse
On Databasesfalse
Catch components statisticsfalse
Catch runtime errorstrue
Catch user errorstrue
Catch user warningstrue


Context List

Context : Default

Name Prompt Need Prompt? Type Value Source




Component List

Component Name Component Type
tLogRow_1tLogRow
tLogRow_2tLogRow
tLogRow_3tLogRow
tLogRow_4tLogRow
tLogRow_5tLogRow
tLogRow_6tLogRow
tMap_1tMap
tMysqlInput_1tMysqlInput
tMysqlRow_1tMysqlRow
tMysqlRow_2tMysqlRow
tMysqlRow_3tMysqlRow
tMysqlRow_4tMysqlRow
tMysqlRow_5tMysqlRow
tMysqlRow_6tMysqlRow

Components Description

Component:   tLogRow

      UNIQUE NAME tLogRow_1 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlRow_1

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Basictrue
Table (print values in cells of a table)false
Vertical (each row is a key/value list)false
Field Separator"|"
Print headerfalse
Print component unique name in front of each output rowfalse
Print schema column name in front of each valuefalse
Use fixed length for valuesfalse
Show Informationfalse
Comentario

Schema for tLogRow_1 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tLogRow

      UNIQUE NAME tLogRow_2 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlRow_2

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Basictrue
Table (print values in cells of a table)false
Vertical (each row is a key/value list)false
Field Separator"|"
Print headerfalse
Print component unique name in front of each output rowfalse
Print schema column name in front of each valuefalse
Use fixed length for valuesfalse
Show Informationfalse
Comentario

Schema for tLogRow_2 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tLogRow

      UNIQUE NAME tLogRow_3 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlRow_3

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Basictrue
Table (print values in cells of a table)false
Vertical (each row is a key/value list)false
Field Separator"|"
Print headerfalse
Print component unique name in front of each output rowfalse
Print schema column name in front of each valuefalse
Use fixed length for valuesfalse
Show Informationfalse
Comentario

Schema for tLogRow_3 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tLogRow

      UNIQUE NAME tLogRow_4 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlRow_4

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Basictrue
Table (print values in cells of a table)false
Vertical (each row is a key/value list)false
Field Separator"|"
Print headerfalse
Print component unique name in front of each output rowfalse
Print schema column name in front of each valuefalse
Use fixed length for valuesfalse
Show Informationfalse
Comentario

Schema for tLogRow_4 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tLogRow

      UNIQUE NAME tLogRow_5 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlRow_5

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Basictrue
Table (print values in cells of a table)false
Vertical (each row is a key/value list)false
Field Separator"|"
Print headerfalse
Print component unique name in front of each output rowfalse
Print schema column name in front of each valuefalse
Use fixed length for valuesfalse
Show Informationfalse
Comentario

Schema for tLogRow_5 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tLogRow

      UNIQUE NAME tLogRow_6 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlRow_6

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Basictrue
Table (print values in cells of a table)false
Vertical (each row is a key/value list)false
Field Separator"|"
Print headerfalse
Print component unique name in front of each output rowfalse
Print schema column name in front of each valuefalse
Use fixed length for valuesfalse
Show Informationfalse
Comentario

Schema for tLogRow_6 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tMysqlInput

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

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Table Name"ds_estadisticas"
Guess Schema""
Query"SELECT ds_estadisticas.Area_id, ds_estadisticas.Anyo, ds_estadisticas.estadistica, ds_estadisticas.variable, ds_estadisticas.valor FROM ds_estadisticas"
Additional JDBC Parameters"noDatetimeStringSync=true"
Codificación"ISO-8859-15"
Enable streamfalse
Trim all the String/Char columnsfalse
Trim column[{SCHEMA_COLUMN=Area_id, TRIM=false}, {SCHEMA_COLUMN=Anyo, TRIM=false}, {SCHEMA_COLUMN=estadistica, TRIM=false}, {SCHEMA_COLUMN=variable, TRIM=false}, {SCHEMA_COLUMN=valor, TRIM=false}]
Show Informationfalse
Comentario

Schema for tMysqlInput_1 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
AnyotrueString4false
estadisticatrueString25false
variabletrueString45false
valorfalsefloat12false

Original Function Parameters:
Component:   tMysqlRow

      UNIQUE NAME tMysqlRow_1 INPUT(S) tLogRow_1
LABEL __TABLE__ OUTPUT(S) none

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Schema
Table Name"dwh_auto"
Queryrow2.registro1
Die on errortrue
Additional JDBC Parameters"noDatetimeStringSync=true"
Propagate QUERY's recordsetfalse
Codificación"ISO-8859-15"
Commit every10000
Show Informationfalse
Comentario

Schema for tMysqlRow_1 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tMysqlRow

      UNIQUE NAME tMysqlRow_2 INPUT(S) tLogRow_2
LABEL __TABLE__ OUTPUT(S) none

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Schema
Table Name"dwh_cultura"
Queryrow3.registro1
Die on errortrue
Additional JDBC Parameters"noDatetimeStringSync=true"
Propagate QUERY's recordsetfalse
Codificación"ISO-8859-15"
Commit every10000
Show Informationfalse
Comentario

Schema for tMysqlRow_2 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tMysqlRow

      UNIQUE NAME tMysqlRow_3 INPUT(S) tLogRow_3
LABEL __TABLE__ OUTPUT(S) none

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Schema
Table Name"dwh_economia"
Queryrow4.registro1
Die on errortrue
Additional JDBC Parameters"noDatetimeStringSync=true"
Propagate QUERY's recordsetfalse
Codificación"ISO-8859-15"
Commit every10000
Show Informationfalse
Comentario

Schema for tMysqlRow_3 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tMysqlRow

      UNIQUE NAME tMysqlRow_4 INPUT(S) tLogRow_4
LABEL __TABLE__ OUTPUT(S) none

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Schema
Table Name"dwh_poblacion"
Queryrow7.registro1
Die on errortrue
Additional JDBC Parameters"noDatetimeStringSync=true"
Propagate QUERY's recordsetfalse
Codificación"ISO-8859-15"
Commit every10000
Show Informationfalse
Comentario

Schema for tMysqlRow_4 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tMysqlRow

      UNIQUE NAME tMysqlRow_5 INPUT(S) tLogRow_5
LABEL __TABLE__ OUTPUT(S) none

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Schema
Table Name"dwh_salud"
Queryrow6.registro1
Die on errortrue
Additional JDBC Parameters"noDatetimeStringSync=true"
Propagate QUERY's recordsetfalse
Codificación"ISO-8859-15"
Commit every10000
Show Informationfalse
Comentario

Schema for tMysqlRow_5 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tMysqlRow

      UNIQUE NAME tMysqlRow_6 INPUT(S) tLogRow_6
LABEL __TABLE__ OUTPUT(S) none

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Schema
Table Name"dwh_viviendas"
Queryrow5.registro1
Die on errortrue
Additional JDBC Parameters"noDatetimeStringSync=true"
Propagate QUERY's recordsetfalse
Codificación"ISO-8859-15"
Commit every10000
Show Informationfalse
Comentario

Schema for tMysqlRow_6 :
Column Key Type Length Precision Nullable Comment
registro1falseStringtrue

Original Function Parameters:
Component:   tMap

      UNIQUE NAME tMap_1 INPUT(S) tMysqlInput_1
LABEL tratamiento_estadisticas OUTPUT(S) tLogRow_1,  tLogRow_2,  tLogRow_3,  tLogRow_4,  tLogRow_5,  tLogRow_6

No image available



Component Parameters:
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 for tMap_1 ( input ):
Mapper table Properties( row1 ):
Properties Values
Name row1
Matching-mode UNIQUE_MATCH
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( row1 ):
Name Type Expression isNullable
Area_idStringfalse
AnyoStringfalse
estadisticaStringfalse
variableStringfalse
valorfloatfalse

Constraint Table Entries( row1 ):
Name Type Expression isNullable

Mapper table for tMap_1 ( output ):
Mapper table Properties( vehiculos ):
Properties Values
Name vehiculos
Matching-mode
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( vehiculos ):
Name Type Expression isNullable
registro1String"UPDATE dwh_auto set " + row1.variable + " = " + row1.valor + " where Area_id = '" + row1.Area_id + "' and Anyo_id = " + row1.Anyo + ";" true

Constraint Table Entries( vehiculos ):
Name Type Expression isNullable

Mapper table Properties( cultura ):
Properties Values
Name cultura
Matching-mode
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( cultura ):
Name Type Expression isNullable
registro1String"UPDATE dwh_cultura set " + row1.variable + " = " + row1.valor + " where Area_id = '" + row1.Area_id + "' and Anyo_id = " + row1.Anyo + ";" true

Constraint Table Entries( cultura ):
Name Type Expression isNullable

Mapper table Properties( economia ):
Properties Values
Name economia
Matching-mode
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( economia ):
Name Type Expression isNullable
registro1String"UPDATE dwh_economia set " + row1.variable + " = " + row1.valor + " where Area_id = '" + row1.Area_id + "' and Anyo_id = " + row1.Anyo + ";" true

Constraint Table Entries( economia ):
Name Type Expression isNullable

Mapper table Properties( poblacion ):
Properties Values
Name poblacion
Matching-mode
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( poblacion ):
Name Type Expression isNullable
registro1String"UPDATE dwh_poblacion set " + row1.variable + " = " + row1.valor + " where Area_id = '" + row1.Area_id + "' and Anyo_id = " + row1.Anyo + ";" true

Constraint Table Entries( poblacion ):
Name Type Expression isNullable

Mapper table Properties( salud ):
Properties Values
Name salud
Matching-mode
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( salud ):
Name Type Expression isNullable
registro1String"UPDATE dwh_salud set " + row1.variable + " = " + row1.valor + " where Area_id = '" + row1.Area_id + "' and Anyo_id = " + row1.Anyo + ";" true

Constraint Table Entries( salud ):
Name Type Expression isNullable

Mapper table Properties( viviendas ):
Properties Values
Name viviendas
Matching-mode
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( viviendas ):
Name Type Expression isNullable
registro1String"UPDATE dwh_viviendas set " + row1.variable + " = " + row1.valor + " where Area_id = '" + row1.Area_id + "' and Anyo_id = " + row1.Anyo + ";" true

Constraint Table Entries( viviendas ):
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

Metadata Table Entries( Var ):
Name Type Expression isNullable

Constraint Table Entries( Var ):
Name Type Expression isNullable