Generated documentation

	Job Documentation
	Generated by Talend Open Studio

PROJECT NAME	London	GENERATION DATE	24-mar-2010 1:09:21
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	Inicializa_Tablas_Hechos
Author	respinosa@terramiticapark.com
Version	0.1
Purpose
Status
Description
Creation	23-mar-2010 21:07:11
Modification	24-mar-2010 0:08:52

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
tFlowToIterate_1	tFlowToIterate
tLogRow_1	tLogRow
tLogRow_2	tLogRow
tMap_1	tMap
tMysqlInput_1	tMysqlInput
tMysqlInput_2	tMysqlInput
tMysqlOutput_1	tMysqlOutput
tMysqlOutput_2	tMysqlOutput
tMysqlOutput_3	tMysqlOutput
tMysqlOutput_4	tMysqlOutput
tMysqlOutput_5	tMysqlOutput
tMysqlOutput_6	tMysqlOutput
tReplicate_1	tReplicate

Components Description

Component: tFlowToIterate

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

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use the default (key, value) in global variables.	true
Show Information	false
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
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

Schema for tLogRow_1 :

Column	Key	Type	Length	Nullable
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

Original Function Parameters:

Component: tLogRow

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

Component Parameters:

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

Schema for tLogRow_2 :

Column	Key	Type	Length	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

Original Function Parameters:

Component: tMysqlInput

	UNIQUE NAME	tMysqlInput_1	INPUT(S)	tFlowToIterate_1
	LABEL	leo_areas	OUTPUT(S)	tMap_1

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 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 stream	false
Trim all the String/Char columns	false
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 Information	false
Comentario

Schema for tMysqlInput_1 :

Column	Key	Type	Length	Nullable
Area_id	true	String	4	false
Area_desc	false	String	25	false
Zona_id	false	short	5	false
Zona_desc	false	String	45	true
Mapa	false	String	45	true

Original Function Parameters:

Component: tMysqlInput

	UNIQUE NAME	tMysqlInput_2	INPUT(S)	none
	LABEL	leo_años	OUTPUT(S)	tLogRow_1

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 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 stream	false
Trim all the String/Char columns	false
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 Information	false
Comentario

Schema for tMysqlInput_2 :

Column	Key	Type	Length	Nullable
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

Original Function Parameters:

Component: tMysqlOutput

	UNIQUE NAME	tMysqlOutput_1	INPUT(S)	tReplicate_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	"dwh_auto"
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	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

Original Function Parameters:

Component: tMysqlOutput

	UNIQUE NAME	tMysqlOutput_2	INPUT(S)	tReplicate_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	"dwh_economia"
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	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

Original Function Parameters:

Component: tMysqlOutput

	UNIQUE NAME	tMysqlOutput_3	INPUT(S)	tReplicate_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	"dwh_cultura"
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	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

Original Function Parameters:

Component: tMysqlOutput

	UNIQUE NAME	tMysqlOutput_4	INPUT(S)	tReplicate_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	"dwh_poblacion"
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	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

Original Function Parameters:

Component: tMysqlOutput

	UNIQUE NAME	tMysqlOutput_5	INPUT(S)	tReplicate_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	"dwh_salud"
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	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

Original Function Parameters:

Component: tMysqlOutput

	UNIQUE NAME	tMysqlOutput_6	INPUT(S)	tReplicate_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	"dwh_viviendas"
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	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

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
Activate	true
tStatCatcher Statistics	false
Show Information	false
Comentario

Schema for tReplicate_1 :

Column	Key	Type	Length	Precision	Nullable	Comment
Area_id	true	String	4		false
Anyo_id	true	Integer			true

Original Function Parameters:

Component: tMap

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

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
Area_id	String	false
Area_desc	String	false
Zona_id	short	false
Zona_desc	String	true
Mapa	String	true

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_id	String	row2.Area_id	false
Anyo_id	Integer	row3.Anyo_id	true

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