Job Documentation
Generated by Talend Open Studio


PROJECT NAME London GENERATION DATE 24-mar-2010 1:09:25
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
NameLlena_Dimension_Geografica
Authorrespinosa@terramiticapark.com
Version0.1
Purpose
Status
Description
Creation23-mar-2010 21:59:49
Modification 23-mar-2010 23:59:03

Job Preview Picture


No image available
tLogRow_1tMap_1tMysqlInput_1tMysqlOutput_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
tLogRow_1tLogRow
tMap_1tMap
tMysqlInput_1tMysqlInput
tMysqlOutput_1tMysqlOutput

Components Description

Component:   tLogRow

      UNIQUE NAME tLogRow_1 INPUT(S) tMap_1
LABEL __UNIQUE_NAME__ OUTPUT(S) tMysqlOutput_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
area_idtrueString4false
area_descfalseString25false
zona_idfalseShort5true
zona_descfalseString45true
mapafalseString45true

Original Function Parameters:
Component:   tMysqlInput

      UNIQUE NAME tMysqlInput_1 INPUT(S) none
LABEL lee_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"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 streamfalse
Trim all the String/Char columnsfalse
Trim column[{SCHEMA_COLUMN=Area_id, TRIM=false}, {SCHEMA_COLUMN=Area_desc, TRIM=false}, {SCHEMA_COLUMN=Circunscripcion, TRIM=false}]
Show Informationfalse
Comentario

Schema for tMysqlInput_1 :
Column Key Type Length Precision Nullable Comment
Area_idtrueString4false
Area_descfalseString25false
CircunscripcionfalseString22true

Original Function Parameters:
Component:   tMysqlOutput

      UNIQUE NAME tMysqlOutput_1 INPUT(S) tLogRow_1
LABEL llena dwd_area 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"dwd_area"
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
Area_descfalseString25false
Zona_idfalseshort5false
Zona_descfalseString45true
MapafalseString45true

Original Function Parameters:
Component:   tMap

      UNIQUE NAME tMap_1 INPUT(S) tMysqlInput_1
LABEL mapea_areas OUTPUT(S) tLogRow_1

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
Area_descStringfalse
CircunscripcionStringtrue

Constraint Table Entries( row1 ):
Name Type Expression isNullable

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

Metadata Table Entries( registros_area ):
Name Type Expression isNullable
area_idStringrow1.Area_id false
area_descStringrow1.Area_desc false
zona_idShort0true
zona_descStringrow1.Circunscripcion true
mapaString"http://web.com"true

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