Generated documentation

	Job Documentation
	Generated by Talend Open Studio

PROJECT NAME	London	GENERATION DATE	24-mar-2010 1:10:19
AUTHOR	respinosa@terramiticapark.com	T.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
Name	London
Language	java
Description	Proyecto BI de Analisis de Datos Públicos

Job Description

Properties	Values
Name	A_vehiculos_aband
Author	respinosa@terramiticapark.com
Version	0.1
Purpose
Status
Description
Creation	19-mar-2010 12:47:22
Modification	24-mar-2010 0:07:34

Job Preview Picture

Job settings

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 List

Context : Default

Name	Prompt	Need Prompt?	Type	Value	Source

Component List

Component Name	Component Type
tFileInputDelimited_3	tFileInputDelimited
tFilterRow_1	tFilterRow
tMap_1	tMap
tMysqlOutput_1	tMysqlOutput
tMysqlOutput_14	tMysqlOutput
tMysqlOutput_2	tMysqlOutput
tMysqlOutput_3	tMysqlOutput
tMysqlOutput_4	tMysqlOutput
tMysqlOutput_5	tMysqlOutput
tMysqlOutput_6	tMysqlOutput
tMysqlOutput_7	tMysqlOutput

Components Description

Component: tFileInputDelimited

	UNIQUE NAME	tFileInputDelimited_3	INPUT(S)	none
	LABEL	vehiculos_aband	OUTPUT(S)	tFilterRow_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
File Name/Input Stream	"D:/BI/Info BI/BLog/Entrada 14.11/Datos/Vehiculos Abandonados.csv"
Row Separator	"\n"
Field Separator	","
Opciones CSV	false
Header	1
Footer	0
Limit
Skip empty rows	false
Die on error	false
Advanced separator(for number)	false
Extract lines at random	false
Trim all column	false
Check column to trim	[{SCHEMA_COLUMN=Code, TRIM=false}, {SCHEMA_COLUMN=Area, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2000_01, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2001_02, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2002_03, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2003_04, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2004_05, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2005_06, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2006_07, TRIM=false}, {SCHEMA_COLUMN=Number_of_abandoned_vehicles___2007_08, TRIM=false}]
Check each row structure against schema	false
Codificación	"US-ASCII"
Split row before field	false
Show Information	false
Comentario

Schema for tFileInputDelimited_3 :

Column	Key	Type	Length	Nullable
Code	false	String	4	true
Area	false	String	22	true
Number_of_abandoned_vehicles___2000_01	false	Integer	6	true
Number_of_abandoned_vehicles___2001_02	false	Integer	6	true
Number_of_abandoned_vehicles___2002_03	false	Integer	6	true
Number_of_abandoned_vehicles___2003_04	false	Integer	6	true
Number_of_abandoned_vehicles___2004_05	false	Integer	6	true
Number_of_abandoned_vehicles___2005_06	false	Integer	6	true
Number_of_abandoned_vehicles___2006_07	false	Integer	5	true
Number_of_abandoned_vehicles___2007_08	false	Integer	5	true

Original Function Parameters:

Component: tFilterRow

	UNIQUE NAME	tFilterRow_1	INPUT(S)	tFileInputDelimited_3
	LABEL	eliminar_no_londres	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Logical operator used to combine conditions	&&
Conditions	[]
Use advanced mode	true
Avanzado	// code sample : use input_row to define the condition. // input_row.columnName1.equals("foo") \|\|!(input_row.columnName2.equals("bar")) // replace the following expression by your own filter condition StringHandling.LEFT(input_row.Code,2).equals("00")
Show Information	false
Comentario

Schema for tFilterRow_1 :

Column	Key	Type	Length	Nullable
Code	false	String	4	true
Area	false	String	22	true
Number_of_abandoned_vehicles___2000_01	false	Integer	6	true
Number_of_abandoned_vehicles___2001_02	false	Integer	6	true
Number_of_abandoned_vehicles___2002_03	false	Integer	6	true
Number_of_abandoned_vehicles___2003_04	false	Integer	6	true
Number_of_abandoned_vehicles___2004_05	false	Integer	6	true
Number_of_abandoned_vehicles___2005_06	false	Integer	6	true
Number_of_abandoned_vehicles___2006_07	false	Integer	5	true
Number_of_abandoned_vehicles___2007_08	false	Integer	5	true

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_1 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_14 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_2 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_3 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_4 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_5 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_6 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMysqlOutput

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	"pcserver7"
Port	"3306"
Base de Datos	"london"
Username	"root"
Password	******
Table	"ds_estadisticas"
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

Schema for tMysqlOutput_7 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Anyo	true	String	4	false
estadistica	true	String	25	false
variable	true	String	45	false
valor	false	float	12	false

Original Function Parameters:

Component: tMap

	UNIQUE NAME	tMap_1	INPUT(S)	tFilterRow_1
	LABEL	prepara_registros	OUTPUT(S)	tMysqlOutput_1, tMysqlOutput_2, tMysqlOutput_3, tMysqlOutput_7, tMysqlOutput_6, tMysqlOutput_5, tMysqlOutput_4, tMysqlOutput_14

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	isNullable
Code	String	true
Area	String	true
Number_of_abandoned_vehicles___2000_01	Integer	true
Number_of_abandoned_vehicles___2001_02	Integer	true
Number_of_abandoned_vehicles___2002_03	Integer	true
Number_of_abandoned_vehicles___2003_04	Integer	true
Number_of_abandoned_vehicles___2004_05	Integer	true
Number_of_abandoned_vehicles___2005_06	Integer	true
Number_of_abandoned_vehicles___2006_07	Integer	true
Number_of_abandoned_vehicles___2007_08	Integer	true

Constraint Table Entries( row2 ):

Name	Type	Expression	isNullable

Mapper table for tMap_1 ( output ):

Mapper table Properties( vehiculos_2001 ):

Properties	Values
Name	vehiculos_2001
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2001 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2001"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2000_01	false

Constraint Table Entries( vehiculos_2001 ):

Name	Type	Expression	isNullable

Mapper table Properties( vehiculos_2002 ):

Properties	Values
Name	vehiculos_2002
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2002 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2002"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2001_02	false

Constraint Table Entries( vehiculos_2002 ):

Name	Type	Expression	isNullable

Mapper table Properties( vehiculos_2003 ):

Properties	Values
Name	vehiculos_2003
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2003 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2003"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2002_03	false

Constraint Table Entries( vehiculos_2003 ):

Name	Type	Expression	isNullable

Mapper table Properties( vehiculos_2004 ):

Properties	Values
Name	vehiculos_2004
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2004 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2004"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2003_04	false

Constraint Table Entries( vehiculos_2004 ):

Name	Type	Expression	isNullable

Mapper table Properties( vehiculos_2005 ):

Properties	Values
Name	vehiculos_2005
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2005 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2005"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2004_05	false

Constraint Table Entries( vehiculos_2005 ):

Name	Type	Expression	isNullable

Mapper table Properties( vehiculos_2006 ):

Properties	Values
Name	vehiculos_2006
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2006 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2006"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2005_06	false

Constraint Table Entries( vehiculos_2006 ):

Name	Type	Expression	isNullable

Mapper table Properties( vehiculos_2007 ):

Properties	Values
Name	vehiculos_2007
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2007 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2007"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2006_07	false

Constraint Table Entries( vehiculos_2007 ):

Name	Type	Expression	isNullable

Mapper table Properties( vehiculos_2008 ):

Properties	Values
Name	vehiculos_2008
Matching-mode
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( vehiculos_2008 ):

Name	Type	Expression	isNullable
Area_id	String	row2.Code	false
Anyo	String	"2008"	false
estadistica	String	"A_vehiculos_aband"	false
variable	String	"N_total_aband"	false
valor	float	row2.Number_of_abandoned_vehicles___2007_08	false

Constraint Table Entries( vehiculos_2008 ):

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