Job Documentation
Generated by Talend Open Studio


PROJECT NAME London GENERATION DATE 24-mar-2010 1:09:21
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
NameInicializa_Tablas_Hechos
Authorrespinosa@terramiticapark.com
Version0.1
Purpose
Status
Description
Creation23-mar-2010 21:07:11
Modification 24-mar-2010 0:08:52

Job Preview Picture


No image available
tFlowToIterate_1tLogRow_1tLogRow_2tMap_1tMysqlInput_1tMysqlInput_2tMysqlOutput_1tMysqlOutput_2tMysqlOutput_3tMysqlOutput_4tMysqlOutput_5tMysqlOutput_6tReplicate_1

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
tFlowToIterate_1tFlowToIterate
tLogRow_1tLogRow
tLogRow_2tLogRow
tMap_1tMap
tMysqlInput_1tMysqlInput
tMysqlInput_2tMysqlInput
tMysqlOutput_1tMysqlOutput
tMysqlOutput_2tMysqlOutput
tMysqlOutput_3tMysqlOutput
tMysqlOutput_4tMysqlOutput
tMysqlOutput_5tMysqlOutput
tMysqlOutput_6tMysqlOutput
tReplicate_1tReplicate

Components Description

Component:   tFlowToIterate

      UNIQUE NAME tFlowToIterate_1 INPUT(S) tLogRow_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlInput_1

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Use the default (key, value) in global variables.true
Show Informationfalse
Comentario

Schema for tFlowToIterate_1 :
Column Key Type Length Precision Nullable Comment

Original Function Parameters:
Component:   tLogRow

      UNIQUE NAME tLogRow_1 INPUT(S) tMysqlInput_2
LABEL visualiza_registro OUTPUT(S) tFlowToIterate_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
Anyo_idtrueint10false
Anyo_descfalseString25false
Siglo_idfalseshort5false
Siglo_descfalseString45false
Decada_idfalseshort5false
Decada_descfalseString45false

Original Function Parameters:
Component:   tLogRow

      UNIQUE NAME tLogRow_2 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tReplicate_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_2 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
Component:   tMysqlInput

      UNIQUE NAME tMysqlInput_1 INPUT(S) tFlowToIterate_1
LABEL leo_areas 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"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 streamfalse
Trim all the String/Char columnsfalse
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 Informationfalse
Comentario

Schema for tMysqlInput_1 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Area_descfalseString25false
Zona_idfalseshort5false
Zona_descfalseString45true
MapafalseString45true

Original Function Parameters:
Component:   tMysqlInput

      UNIQUE NAME tMysqlInput_2 INPUT(S) none
LABEL leo_años OUTPUT(S) tLogRow_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"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 streamfalse
Trim all the String/Char columnsfalse
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 Informationfalse
Comentario

Schema for tMysqlInput_2 :
Column Key Type Length Precision Nullable Comment
Anyo_idtrueint10false
Anyo_descfalseString25false
Siglo_idfalseshort5false
Siglo_descfalseString45false
Decada_idfalseshort5false
Decada_descfalseString45false

Original Function Parameters:
Component:   tMysqlOutput

      UNIQUE NAME tMysqlOutput_1 INPUT(S) tReplicate_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******
Table"dwh_auto"
Action on tableNONE
Action on dataINSERT
Schema
Die on errorfalse
Additional JDBC Parameters"noDatetimeStringSync=true"
Extend Inserttrue
Note(Not compatible with reject links)
Number of rows per insert100
Codificación"ISO-8859-15"
Commit every10000
Columnas adicionales[]
Use field optionsfalse
Use Hint Optionsfalse
Enable debug modefalse
Use duplicate key update mode insertfalse
Show Informationfalse
Comentario

Schema for tMysqlOutput_1 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
Component:   tMysqlOutput

      UNIQUE NAME tMysqlOutput_2 INPUT(S) tReplicate_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******
Table"dwh_economia"
Action on tableNONE
Action on dataINSERT
Schema
Die on errorfalse
Additional JDBC Parameters"noDatetimeStringSync=true"
Extend Inserttrue
Note(Not compatible with reject links)
Number of rows per insert100
Codificación"ISO-8859-15"
Commit every10000
Columnas adicionales[]
Use field optionsfalse
Use Hint Optionsfalse
Enable debug modefalse
Use duplicate key update mode insertfalse
Show Informationfalse
Comentario

Schema for tMysqlOutput_2 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
Component:   tMysqlOutput

      UNIQUE NAME tMysqlOutput_3 INPUT(S) tReplicate_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******
Table"dwh_cultura"
Action on tableNONE
Action on dataINSERT
Schema
Die on errorfalse
Additional JDBC Parameters"noDatetimeStringSync=true"
Extend Inserttrue
Note(Not compatible with reject links)
Number of rows per insert100
Codificación"ISO-8859-15"
Commit every10000
Columnas adicionales[]
Use field optionsfalse
Use Hint Optionsfalse
Enable debug modefalse
Use duplicate key update mode insertfalse
Show Informationfalse
Comentario

Schema for tMysqlOutput_3 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
Component:   tMysqlOutput

      UNIQUE NAME tMysqlOutput_4 INPUT(S) tReplicate_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******
Table"dwh_poblacion"
Action on tableNONE
Action on dataINSERT
Schema
Die on errorfalse
Additional JDBC Parameters"noDatetimeStringSync=true"
Extend Inserttrue
Note(Not compatible with reject links)
Number of rows per insert100
Codificación"ISO-8859-15"
Commit every10000
Columnas adicionales[]
Use field optionsfalse
Use Hint Optionsfalse
Enable debug modefalse
Use duplicate key update mode insertfalse
Show Informationfalse
Comentario

Schema for tMysqlOutput_4 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
Component:   tMysqlOutput

      UNIQUE NAME tMysqlOutput_5 INPUT(S) tReplicate_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******
Table"dwh_salud"
Action on tableNONE
Action on dataINSERT
Schema
Die on errorfalse
Additional JDBC Parameters"noDatetimeStringSync=true"
Extend Inserttrue
Note(Not compatible with reject links)
Number of rows per insert100
Codificación"ISO-8859-15"
Commit every10000
Columnas adicionales[]
Use field optionsfalse
Use Hint Optionsfalse
Enable debug modefalse
Use duplicate key update mode insertfalse
Show Informationfalse
Comentario

Schema for tMysqlOutput_5 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
Component:   tMysqlOutput

      UNIQUE NAME tMysqlOutput_6 INPUT(S) tReplicate_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******
Table"dwh_viviendas"
Action on tableNONE
Action on dataINSERT
Schema
Die on errorfalse
Additional JDBC Parameters"noDatetimeStringSync=true"
Extend Inserttrue
Note(Not compatible with reject links)
Number of rows per insert100
Codificación"ISO-8859-15"
Commit every10000
Columnas adicionales[]
Use field optionsfalse
Use Hint Optionsfalse
Enable debug modefalse
Use duplicate key update mode insertfalse
Show Informationfalse
Comentario

Schema for tMysqlOutput_6 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
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

Component Parameters:
Properties Values
Activatetrue
tStatCatcher Statisticsfalse
Show Informationfalse
Comentario

Schema for tReplicate_1 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Anyo_idtrueIntegertrue

Original Function Parameters:
Component:   tMap

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

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( row2 ):
Properties Values
Name row2
Matching-mode UNIQUE_MATCH
isMinimized false
isReject false
isRejectInnerJoin false
isInnerJoin false

Metadata Table Entries( row2 ):
Name Type Expression isNullable
Area_idStringfalse
Area_descStringfalse
Zona_idshortfalse
Zona_descStringtrue
MapaStringtrue

Constraint Table Entries( row2 ):
Name Type Expression isNullable

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

Metadata Table Entries( salida ):
Name Type Expression isNullable
Area_idStringrow2.Area_id false
Anyo_idIntegerrow3.Anyo_idtrue

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