Generated documentation

	Job Documentation
	Generated by Talend Open Studio

PROJECT NAME	Proyecto Ventas BI	GENERATION DATE	11-ene-2010 23:29:32
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	Proyecto Ventas BI
Language	java
Description	Proyecto Ventas EnoBI

Job Description

Properties	Values
Name	DimCliente
Author	respinosa@terramiticapark.com
Version	0.1
Purpose	ETL Dimension Cliente
Status
Description
Creation	28-may-2009 19:27:16
Modification	11-ene-2010 23:29:32

Job Preview Picture

Job settings

Extra settings

Name	Value
COMP_DEFAULT_FILE_DIR	C:/TOS-Win32-r33789-V4.0.0M1/workspace
Multi thread execution	false
Implicit tContextLoad	false

Stats & Logs

Name	Value
Use statistics (tStatCatcher)	true
Use logs (tLogCatcher)	true
Use volumetrics (tFlowMeterCatcher)	true
On Console	false
On Files	true
File Path	"C:/temp/talend"
Log File Name	"logs_file.txt"
Meter file name	"meter_file.txt"
Stats File Name	"stats_file.txt"
On Databases	true
Property Type
Propiedad	REPOSITORY
Property:source	stage_area
Db Type	tMysqlOutput
Host	"localhost"
Port	"3306"
Db Name	"stage_area"
Additional parameters	"noDatetimeStringSync=true"
Schema	""
Usuario	"root"
Password	******
Base de Datos	""
Logs Table	"logs"
Meter Table	"meter"
Stats Table	"stats"
Catch components statistics	true
Catch runtime errors	true
Catch user errors	true
Catch user warnings	true

Context List

Context : Default

Name	Prompt	Need Prompt?	Type	Value	Source
tm_int_Sid	tm_int_Sid?	false	id_String	MG1	tm_int
tm_int_Login	tm_int_Login?	false	id_String	system	tm_int
tm_int_Port	tm_int_Port?	false	id_String	1527	tm_int
tm_int_Schema	tm_int_Schema?	false	id_String	SAPR3	tm_int
tm_int_Password	tm_int_Password?	false	id_Password	******	tm_int
tm_int_Server	tm_int_Server?	false	id_String	tm_int	tm_int
enobi_AdditionalParams	enobi_AdditionalParams?	false	id_String	noDatetimeStringSync=true	enobi
enobi_Server	enobi_Server?	false	id_String	localhost	enobi
enobi_Login	enobi_Login?	false	id_String	root	enobi
enobi_Port	enobi_Port?	false	id_String	3306	enobi
enobi_Database	enobi_Database?	false	id_String	enobi	enobi
enobi_Password	enobi_Password?	false	id_Password	******	enobi
stage_area_AdditionalParams	stage_area_AdditionalParams?	false	id_String	noDatetimeStringSync=true	stage_area
stage_area_Password	stage_area_Password?	false	id_Password	******	stage_area
stage_area_Port	stage_area_Port?	false	id_String	3306	stage_area
stage_area_Database	stage_area_Database?	false	id_String	stage_area	stage_area
stage_area_Server	stage_area_Server?	false	id_String	localhost	stage_area
stage_area_Login	stage_area_Login?	false	id_String	root	stage_area

Component List

Component Name	Component Type
tFlowToIterate_1	tFlowToIterate
tLogCatcher_1	tLogCatcher
tLogRow_2	tLogRow
tMap_1	tMap
tMap_2	tMap
tMysqlInput_1	tMysqlInput
tMysqlOutput_1	tMysqlOutput
tMysqlSCD_1	tMysqlSCD
tOracleInput_1	tOracleInput
tOracleInput_2	tOracleInput
tOracleInput_3	tOracleInput
tOracleInput_4	tOracleInput
tOracleInput_5	tOracleInput
tOracleInput_6	tOracleInput
tOracleInput_7	tOracleInput
tPrejob_1	tPrejob
tReplace_1	tReplace
tReplicate_1	tReplicate
tSendMail_1	tSendMail
tWarn_1	tWarn
tWarn_2	tWarn

Components Description

Component: tFlowToIterate

	UNIQUE NAME	tFlowToIterate_1	INPUT(S)	tLogCatcher_1
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	tSendMail_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: tLogCatcher

	UNIQUE NAME	tLogCatcher_1	INPUT(S)	tWarn_1
	LABEL	CONTROL_ERRORES	OUTPUT(S)	tFlowToIterate_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Catch Java Exception	true
Catch tDie	true
Catch tWarn	false
Show Information	false
Comentario	Disparo el componente tLogCatcher, solo para los mensajes de error (die) y para las excepciones Java. Este componente se quedara escuchando durante la ejecución de todos los pasos del job, y en el caso de que haya error, se activara y producira el envio de un email de notificación.

Schema for tLogCatcher_1 :

Column	Key	Type	Length	Nullable
moment	false	java.util.Date		true
pid	false	String	20	true
root_pid	false	String	20	true
father_pid	false	String	20	true
project	false	String	50	true
job	false	String	255	true
context	false	String	50	true
priority	false	Integer	3	true
type	false	String	255	true
origin	false	String	255	true
message	false	String	255	true
code	false	Integer	3	true

Original Function Parameters:

Component: tLogRow

	UNIQUE NAME	tLogRow_2	INPUT(S)	tMap_1, tOracleInput_4, tOracleInput_5
	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	Nullable	Comment
cliente_id	true	long	10	false	Codigo cliente (PK): clave
cliente_desc	false	String	40	false	Desc Cliente
agrupador_id	false	long	10	false	Identificador Agrupador de Clientes
agrupador_desc	false	String	40	false	Desc agrupador de clientes
comercial_id	false	String	20	false	Nombre del Comercial Asignado
canal_id	false	int	5	false	Identificador canal de venta
canal_desc	false	String	20	false	Desc canal de venta
tipocl_id	false	int	5	false	Identificador del tipo de cliente
tipocl_desc	false	String	20	false	Desc del tipo de cliente
pais_id	false	String	15	false	Descripcion Pais
region_id	false	String	20	false	Descripcion Region
provincia_id	false	String	20	false	Descripcion Provincia
cpostal_id	false	String	10	false	Id Codigo Postal
poblacion_id	false	String	35	false	Descripcion Poblacion
nielsen_id	false	String	10	false	Codigo Nielsen para estudios de mercado
clubvinos_id	false	long	10	false	Codigo Club Vinos

Original Function Parameters:

Component: tMysqlInput

	UNIQUE NAME	tMysqlInput_1	INPUT(S)	none
	LABEL	LEER_DWD_CLIENTE	OUTPUT(S)	tMap_2

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Host	context.enobi_Server
Port	context.enobi_Port
Base de Datos	context.enobi_Database
Username	context.enobi_Login
Password	context.enobi_Password
Table Name	"dwd_cliente"
Guess Schema	""
Query	"SELECT dwd_cliente.cliente_id, dwd_cliente.cliente_desc, dwd_cliente.agrupador_id, dwd_cliente.agrupador_desc, dwd_cliente.comercial_id, dwd_cliente.canal_id, dwd_cliente.canal_desc, dwd_cliente.tipocl_id, dwd_cliente.tipocl_desc, dwd_cliente.pais_id, dwd_cliente.region_id, dwd_cliente.provincia_id, dwd_cliente.cpostal_id, dwd_cliente.poblacion_id, dwd_cliente.nielsen_id, dwd_cliente.clubvinos_id FROM dwd_cliente WHERE cliente_id = " + (globalMap.get("var.cliente_id"))
Additional JDBC Parameters	context.enobi_AdditionalParams
Codificación	"ISO-8859-15"
Enable stream	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=cliente_id, TRIM=false}, {SCHEMA_COLUMN=cliente_desc, TRIM=false}, {SCHEMA_COLUMN=agrupador_id, TRIM=false}, {SCHEMA_COLUMN=agrupador_desc, TRIM=false}, {SCHEMA_COLUMN=comercial_id, TRIM=false}, {SCHEMA_COLUMN=canal_id, TRIM=false}, {SCHEMA_COLUMN=canal_desc, TRIM=false}, {SCHEMA_COLUMN=tipocl_id, TRIM=false}, {SCHEMA_COLUMN=tipocl_desc, TRIM=false}, {SCHEMA_COLUMN=pais_id, TRIM=false}, {SCHEMA_COLUMN=region_id, TRIM=false}, {SCHEMA_COLUMN=provincia_id, TRIM=false}, {SCHEMA_COLUMN=cpostal_id, TRIM=false}, {SCHEMA_COLUMN=poblacion_id, TRIM=false}, {SCHEMA_COLUMN=nielsen_id, TRIM=false}, {SCHEMA_COLUMN=clubvinos_id, TRIM=false}]
Show Information	false
Comentario

Schema for tMysqlInput_1 :

Column	Key	Type	Length	Nullable	Comment
cliente_id	true	long	10	false	Codigo cliente (PK): clave
cliente_desc	false	String	40	false	Desc Cliente
agrupador_id	false	long	10	false	Identificador Agrupador de Clientes
agrupador_desc	false	String	40	false	Desc agrupador de clientes
comercial_id	false	String	20	false	Nombre del Comercial Asignado
canal_id	false	int	5	false	Identificador canal de venta
canal_desc	false	String	20	false	Desc canal de venta
tipocl_id	false	int	5	false	Identificador del tipo de cliente
tipocl_desc	false	String	20	false	Desc del tipo de cliente
pais_id	false	String	15	false	Descripcion Pais
region_id	false	String	20	false	Descripcion Region
provincia_id	false	String	20	false	Descripcion Provincia
cpostal_id	false	String	10	false	Id Codigo Postal
poblacion_id	false	String	35	false	Descripcion Poblacion
nielsen_id	false	String	10	false	Codigo Nielsen para estudios de mercado
clubvinos_id	false	long	10	false	Codigo Club Vinos

Original Function Parameters:

Component: tMysqlOutput

	UNIQUE NAME	tMysqlOutput_1	INPUT(S)	tMap_2, tMysqlInput_1
	LABEL	ACTUALIZA_DWD_CLIENTE	OUTPUT(S)	tWarn_2

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	true
Use an existing connection	false
Host	context.enobi_Server
Port	context.enobi_Port
Base de Datos	context.enobi_Database
Username	context.enobi_Login
Password	context.enobi_Password
Table	"dwd_cliente"
Action on table	NONE
Action on data	UPDATE_OR_INSERT
Schema
Die on error	true
Additional JDBC Parameters	context.enobi_AdditionalParams
Codificación	"ISO-8859-15"
Commit every	10000
Columnas adicionales	[]
Use field options	false
Use Hint Options	false
Enable debug mode	false
Show Information	false
Comentario

Schema for tMysqlOutput_1 :

Column	Key	Type	Length	Nullable	Comment
cliente_id	true	long	10	false	Codigo cliente (PK): clave
cliente_desc	false	String	40	false	Desc Cliente
agrupador_id	false	long	10	false	Identificador Agrupador de Clientes
agrupador_desc	false	String	40	false	Desc agrupador de clientes
comercial_id	false	String	20	false	Nombre del Comercial Asignado
canal_id	false	int	5	false	Identificador canal de venta
canal_desc	false	String	20	false	Desc canal de venta
tipocl_id	false	int	5	false	Identificador del tipo de cliente
tipocl_desc	false	String	20	false	Desc del tipo de cliente
pais_id	false	String	15	false	Descripcion Pais
region_id	false	String	20	false	Descripcion Region
provincia_id	false	String	20	false	Descripcion Provincia
cpostal_id	false	String	10	false	Id Codigo Postal
poblacion_id	false	String	35	false	Descripcion Poblacion
nielsen_id	false	String	10	false	Codigo Nielsen para estudios de mercado
clubvinos_id	false	long	10	false	Codigo Club Vinos

Original Function Parameters:

Component: tOracleInput

	UNIQUE NAME	tOracleInput_1	INPUT(S)	none
	LABEL	LECT_CANAL_CLIENTES	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Connection Type	ORACLE_SID
DB Version	ojdbc14-9i.jar
Host	context.tm_int_Server
Port	context.tm_int_Port
Base de Datos	context.tm_int_Sid
Oracle schema	context.tm_int_Schema
Username	context.tm_int_Login
Password	context.tm_int_Password
Table Name	"KNVV"
Guess Schema	""
Query	"select kunnr, kdgrp, vtweg from sapr3.knvv where kunnr between 300000000 and 399999999"
Codificación	"ISO-8859-15"
Use cursor	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=kunnr, TRIM=false}, {SCHEMA_COLUMN=kdgrp, TRIM=false}, {SCHEMA_COLUMN=vtweg, TRIM=false}]
Show Information	false
Comentario

Schema for tOracleInput_1 :

Column	Key	Type	Nullable
kunnr	true	String	false
kdgrp	false	String	false
vtweg	false	String	false

Original Function Parameters:

Component: tOracleInput

	UNIQUE NAME	tOracleInput_2	INPUT(S)	none
	LABEL	LECT_MAESTRO_CLIENTES	OUTPUT(S)	tReplace_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	true
Use an existing connection	false
Connection Type	ORACLE_SID
DB Version	ojdbc14-9i.jar
Host	context.tm_int_Server
Port	context.tm_int_Port
Base de Datos	context.tm_int_Sid
Oracle schema	context.tm_int_Schema
Username	context.tm_int_Login
Password	context.tm_int_Password
Table Name	"KNA1"
Guess Schema	""
Query	"select kunnr,name1,konzs,psofg,land1,regio,pstlz,ort01,niels from sapr3.kna1 where kunnr between 300000000 and 399999999"
Codificación	"ISO-8859-15"
Use cursor	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=kunnr, TRIM=false}, {SCHEMA_COLUMN=name1, TRIM=false}, {SCHEMA_COLUMN=konzs, TRIM=false}, {SCHEMA_COLUMN=psofg, TRIM=false}, {SCHEMA_COLUMN=land1, TRIM=false}, {SCHEMA_COLUMN=regio, TRIM=false}, {SCHEMA_COLUMN=pstlz, TRIM=false}, {SCHEMA_COLUMN=ort01, TRIM=false}, {SCHEMA_COLUMN=niels, TRIM=false}]
Show Information	false
Comentario

Schema for tOracleInput_2 :

Column	Key	Type	Length	Nullable	Comment
kunnr	true	String	10	false	Codigo Cliente
name1	false	String	40	false	Nombre
konzs	false	String	10	true	Agrupador Cliente
psofg	false	String	10	true	Responsable Comercial
land1	false	String	3	true	Pais
regio	false	String	3	true	Provincia
pstlz	false	String	10	true	Codigo Postal
ort01	false	String	35	true	Poblacion
niels	false	String	2	true	Codigo Nielsen

Original Function Parameters:

Component: tOracleInput

	UNIQUE NAME	tOracleInput_3	INPUT(S)	none
	LABEL	LECT_DESC_TIPOCLIENTE	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Connection Type	ORACLE_SID
DB Version	ojdbc14-9i.jar
Host	context.tm_int_Server
Port	context.tm_int_Port
Base de Datos	context.tm_int_Sid
Oracle schema	context.tm_int_Schema
Username	context.tm_int_Login
Password	context.tm_int_Password
Table Name	"T151T"
Guess Schema	""
Query	"select kdgrp,ktext from sapr3.T151t where SPRAS = 'S'"
Codificación	"ISO-8859-15"
Use cursor	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=kdgrp, TRIM=false}, {SCHEMA_COLUMN=ktext, TRIM=false}]
Show Information	false
Comentario

Schema for tOracleInput_3 :

Column	Key	Type	Length	Precision	Nullable	Comment
kdgrp	false	String			true
ktext	false	String			true

Original Function Parameters:

Component: tOracleInput

	UNIQUE NAME	tOracleInput_4	INPUT(S)	none
	LABEL	LECT_DESC_PAIS	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Connection Type	ORACLE_SID
DB Version	ojdbc14-9i.jar
Host	context.tm_int_Server
Port	context.tm_int_Port
Base de Datos	context.tm_int_Sid
Oracle schema	context.tm_int_Schema
Username	context.tm_int_Login
Password	context.tm_int_Password
Table Name	"T005T"
Guess Schema	""
Query	"select LAND1,LANDX from sapr3.t005t where spras = 'S'"
Codificación	"ISO-8859-15"
Use cursor	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=land1, TRIM=false}, {SCHEMA_COLUMN=landx, TRIM=false}]
Show Information	false
Comentario

Schema for tOracleInput_4 :

Column	Key	Type	Length	Precision	Nullable	Comment
land1	false	String			true
landx	false	String			true

Original Function Parameters:

Component: tOracleInput

	UNIQUE NAME	tOracleInput_5	INPUT(S)	none
	LABEL	LECT_DESC_PROVINCIA	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Connection Type	ORACLE_SID
DB Version	ojdbc14-9i.jar
Host	context.tm_int_Server
Port	context.tm_int_Port
Base de Datos	context.tm_int_Sid
Oracle schema	context.tm_int_Schema
Username	context.tm_int_Login
Password	context.tm_int_Password
Table Name	"T005U"
Guess Schema	""
Query	"select LAND1,BLAND,BEZEI from SAPR3.T005U where spras = 'S'"
Codificación	"ISO-8859-15"
Use cursor	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=land1, TRIM=false}, {SCHEMA_COLUMN=bland, TRIM=false}, {SCHEMA_COLUMN=bezei, TRIM=false}]
Show Information	false
Comentario

Schema for tOracleInput_5 :

Column	Key	Type	Nullable
land1	false	String	true
bland	false	String	true
bezei	false	String	true

Original Function Parameters:

Component: tOracleInput

	UNIQUE NAME	tOracleInput_6	INPUT(S)	none
	LABEL	LECT_DESC_CANAL	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Connection Type	ORACLE_SID
DB Version	ojdbc14-9i.jar
Host	context.tm_int_Server
Port	context.tm_int_Port
Base de Datos	context.tm_int_Sid
Oracle schema	context.tm_int_Schema
Username	context.tm_int_Login
Password	context.tm_int_Password
Table Name	"TVTWT"
Guess Schema	""
Query	"select VTWEG,VTEXT from sapr3.TVTWT where SPRAS = 'S'"
Codificación	"ISO-8859-15"
Use cursor	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=VTWEG, TRIM=false}, {SCHEMA_COLUMN=VTEXT, TRIM=false}]
Show Information	false
Comentario

Schema for tOracleInput_6 :

Column	Key	Type	Length	Precision	Nullable	Comment
VTWEG	true	String	2		false
VTEXT	false	String	20		false

Original Function Parameters:

Component: tOracleInput

	UNIQUE NAME	tOracleInput_7	INPUT(S)	none
	LABEL	LECT_NOMBRE_AGRUPADOR	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Use an existing connection	false
Connection Type	ORACLE_SID
DB Version	ojdbc14-9i.jar
Host	context.tm_int_Server
Port	context.tm_int_Port
Base de Datos	context.tm_int_Sid
Oracle schema	context.tm_int_Schema
Username	context.tm_int_Login
Password	context.tm_int_Password
Table Name	"KNA1"
Guess Schema	""
Query	"select kunnr,name1 from sapr3.kna1 where kunnr between 300000000 and 399999999"
Codificación	"ISO-8859-15"
Use cursor	false
Trim all the String/Char columns	false
Trim column	[{SCHEMA_COLUMN=kunnr, TRIM=false}, {SCHEMA_COLUMN=name1, TRIM=false}]
Show Information	false
Comentario

Schema for tOracleInput_7 :

Column	Key	Type	Length	Precision	Nullable	Comment
kunnr	true	String			false
name1	false	String			false

Original Function Parameters:

Component: tPrejob

	UNIQUE NAME	tPrejob_1	INPUT(S)	none
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	tWarn_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Show Information	false
Comentario

Original Function Parameters:

Component: tReplace

	UNIQUE NAME	tReplace_1	INPUT(S)	tOracleInput_2
	LABEL	AJUSTE_CAMPOS	OUTPUT(S)	tMap_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Simple mode ( search with regexp pattern or glob expression)	true
Search/Replace	ng" length="20" precision="" nullable="true" comment=""/> <column name="project" key="false" type="String" length="50" precision="" nullable="true" comment=""/> <column name="job" key="false" type="String" length="255" precision="" nullable="true" comment=""/> <column name="context" key="false" type="String" length="50" precision="" nullable="true" coTTERN=" "}, {USE_GLOB=false, CASE_SENSITIVE=false, INPUT_COLUMN=land1, REPLACE_STRING="ES", COMMENT=, WHOLE_WORD=true, SEARCH_PATTERN=" "}, {USE_GLOB=false, CASE_SENSITIVE=false, INPUT_COLUMN=regio, REPLACE_STRING="03", COMMENT=, WHOLE_WORD=true, SEARCH_PATTERN=" "}, {USE_GLOB=false, CASE_SENSITIVE=false, INPUT_COLUMN=pstlz, REPLACE_STRING="03502", COMMENT=, WHOLE_WORD=true, SEARCH_PATTERN=" "}, {USE_GLOB=false, CASE_SENSITIVE=false, INPUT_COLUMN=ort01, REPLACE_STRING="BENIDORM", COMMENT=, WHOLE_WORD=true, SEARCH_PATTERN=" "}]
Advanced mode ( search with regexp pattern )	false
Show Information	false
Comentario

Schema for tReplace_1 :

Column	Key	Type	Length	Nullable	Comment
kunnr	true	String	10	false	Codigo Cliente
name1	false	String	40	false	Nombre
konzs	false	String	10	true	Agrupador Cliente
psofg	false	String	10	true	Responsable Comercial
land1	false	String	3	true	Pais
regio	false	String	3	true	Provincia
pstlz	false	String	10	true	Codigo Postal
ort01	false	String	35	true	Poblacion
niels	false	String	2	true	Codigo Nielsen

Original Function Parameters:

Component: tReplicate

	UNIQUE NAME	tReplicate_1	INPUT(S)	tLogRow_2, tOracleInput_1, tOracleInput_7, tOracleInput_3, tOracleInput_6
	LABEL	__UNIQUE_NAME__	OUTPUT(S)	tMap_2, tMysqlSCD_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Show Information	false
Comentario

Schema for tReplicate_1 :

Column	Key	Type	Length	Nullable	Comment
cliente_id	true	long	10	false	Column generated by scd editor.
cliente_desc	false	String	40	false	Column generated by scd editor.
agrupador_id	false	long	10	false	Column generated by scd editor.
agrupador_desc	false	String	40	false	Column generated by scd editor.
comercial_id	false	String	20	false	Column generated by scd editor.
canal_id	false	int	5	false	Column generated by scd editor.
canal_desc	false	String	20	false	Column generated by scd editor.
tipocl_id	false	int	5	false	Column generated by scd editor.
tipocl_desc	false	String	20	false	Column generated by scd editor.
pais_id	false	String	15	false	Column generated by scd editor.
region_id	false	String	20	false	Column generated by scd editor.
provincia_id	false	String	20	false	Column generated by scd editor.
cpostal_id	false	String	10	false	Column generated by scd editor.
poblacion_id	false	String	35	false	Column generated by scd editor.
nielsen_id	false	String	10	false	Column generated by scd editor.
clubvinos_id	false	long	10	false	Column generated by scd editor.

Original Function Parameters:

Component: tSendMail

	UNIQUE NAME	tSendMail_1	INPUT(S)	tFlowToIterate_1
	LABEL	ENVIO_EMAIL_NOTIF	OUTPUT(S)	none

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
To	"respinosamilla@yahoo.com"
From	"respinosamilla@gmail.com"
Show sender's name?	false
Cc	"respinosamilla@gmail.com"
Bcc
Subject	"Error en ejecución del Job " + jobName
Message	"Cancelado el trabajo " + jobName + "\nen el paso " + row11.origin + "\ncon el mensaje de error " + row11.message
Die if the attachment file doesn't exist.	true
Attachments	[]
Other headers	[]
SMTP host	"smtp.gmail.com"
SMTP port	465
SSL Support	true
STARTTLS Support	false
Importance	High
Need authentication?	true
Username	"respinosamilla@gmail.com"
Password	"atitelavoyadecir"
Die on error	true
MIME subtype from the 'text' MIME type	plain
charset used for encoding message	"ISO-8859-15"
Show Information	false
Comentario	En el caso de error o excepción Java, enviamos un email informativo, indicado que el job se ha parado, en que paso y con que mensaje de error.

Schema for tSendMail_1 :

Column	Key	Type	Length	Nullable
moment	false	java.util.Date		true
pid	false	String	20	true
root_pid	false	String	20	true
father_pid	false	String	20	true
project	false	String	50	true
job	false	String	255	true
context	false	String	50	true
priority	false	Integer	3	true
type	false	String	255	true
origin	false	String	255	true
message	false	String	255	true
code	false	Integer	3	true

Original Function Parameters:

Component: tWarn

	UNIQUE NAME	tWarn_1	INPUT(S)	tPrejob_1
	LABEL	MENSAJE_LOG_INICIO	OUTPUT(S)	tLogCatcher_1

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Warn message	"INICIO"
Codigo	0
Priority	3
Show Information	false
Comentario	Utilizando el componente tWarn, genero un mensaje en el log correspondiente al INICIO del trabajo (generara un registro en la tabla LOGS).

Schema for tWarn_1 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component: tWarn

	UNIQUE NAME	tWarn_2	INPUT(S)	tMysqlOutput_1
	LABEL	MENSAJE_LOG_FIN	OUTPUT(S)	none

Component Parameters:

Properties	Values
Activate	true
tStatCatcher Statistics	false
Warn message	"FIN"
Codigo	0
Priority	3
Show Information	false
Comentario	Utilizando el componente tWarn, genero un mensaje en el log correspondiente al FIN correcto del trabajo (generara un registro en la tabla LOGS).

Schema for tWarn_2 :

Column	Key	Type	Length	Precision	Nullable	Comment

Original Function Parameters:

Component: tMap

	UNIQUE NAME	tMap_1	INPUT(S)	tLogRow_2, tOracleInput_1, tOracleInput_7, tOracleInput_3, tOracleInput_6
	LABEL	MAPEO_CLIENTE	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
kunnr	String	false
name1	String	false
konzs	String	true
psofg	String	true
land1	String	true
regio	String	true
pstlz	String	true
ort01	String	true
niels	String	true

Constraint Table Entries( row2 ):

Name	Type	Expression	isNullable

Mapper table Properties( row3 ):

Properties	Values
Name	row3
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( row3 ):

Name	Type	Expression	isNullable
kunnr	String	row2.konzs	false
name1	String		false

Constraint Table Entries( row3 ):

Name	Type	Expression	isNullable

Mapper table Properties( row6 ):

Properties	Values
Name	row6
Matching-mode	UNIQUE_MATCH
isMinimized	true
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( row6 ):

Name	Type	Expression	isNullable
land1	String	row2.land1	true
landx	String		true

Constraint Table Entries( row6 ):

Name	Type	Expression	isNullable

Mapper table Properties( row7 ):

Properties	Values
Name	row7
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( row7 ):

Name	Type	Expression	isNullable
land1	String	row2.land1	true
bland	String	row2.regio	true
bezei	String		true

Constraint Table Entries( row7 ):

Name	Type	Expression	isNullable

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
kunnr	String	row2.kunnr	false
kdgrp	String		false
vtweg	String		false

Constraint Table Entries( row1 ):

Name	Type	Expression	isNullable

Mapper table Properties( row9 ):

Properties	Values
Name	row9
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( row9 ):

Name	Type	Expression	isNullable
kdgrp	String	row1.kdgrp	true
ktext	String		true

Constraint Table Entries( row9 ):

Name	Type	Expression	isNullable

Mapper table Properties( row5 ):

Properties	Values
Name	row5
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( row5 ):

Name	Type	Expression	isNullable
VTWEG	String	row1.vtweg	false
VTEXT	String		false

Constraint Table Entries( row5 ):

Name	Type	Expression	isNullable

Mapper table for tMap_1 ( output ):

Mapper table Properties( row4 ):

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

Metadata Table Entries( row4 ):

Name	Type	Expression	isNullable
cliente_id	long	Long.valueOf(StringHandling.RIGHT(row2.kunnr,10))	false
cliente_desc	String	StringHandling.UPCASE(row2.name1)	false
agrupador_id	long	Long.valueOf(StringHandling.RIGHT(row2.konzs,10))	false
agrupador_desc	String	StringHandling.UPCASE(row3.name1 )	false
comercial_id	String	Relational.ISNULL(row2.psofg)?"SIN ASIGNAR":row2.psofg	false
canal_id	int	Mathematical.INT(row1.vtweg)	false
canal_desc	String	StringHandling.UPCASE(row5.VTEXT)	false
tipocl_id	int	Mathematical.INT(row1.kdgrp)	false
tipocl_desc	String	StringHandling.UPCASE(row9.ktext)	false
pais_id	String	StringHandling.UPCASE(row6.landx)	false
region_id	String	"REGION"	false
provincia_id	String	StringHandling.UPCASE(Relational.ISNULL(row7.bezei )?"SIN ASIGNAR":row7.bezei )	false
cpostal_id	String	row2.pstlz	false
poblacion_id	String	StringHandling.UPCASE(row2.ort01 )	false
nielsen_id	String	row2.niels	false
clubvinos_id	long	Long.valueOf("99999999")	false

Constraint Table Entries( row4 ):

Name	Type	Expression	isNullable

Mapper table for tMap_1 ( var ):

Mapper table Properties( Var ):

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

Metadata Table Entries( Var ):

Name	Type	Expression	isNullable

Constraint Table Entries( Var ):

Name	Type	Expression	isNullable

Component: tMap

	UNIQUE NAME	tMap_2	INPUT(S)	tMap_2, tMysqlInput_1
	LABEL	VERIF_MODIFICACIONES	OUTPUT(S)	tMysqlOutput_1

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_2 ( input ):

Mapper table Properties( row8 ):

Properties	Values
Name	row8
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( row8 ):

Name	Type	isNullable
cliente_id	long	false
cliente_desc	String	false
agrupador_id	long	false
agrupador_desc	String	false
comercial_id	String	false
canal_id	int	false
canal_desc	String	false
tipocl_id	int	false
tipocl_desc	String	false
pais_id	String	false
region_id	String	false
provincia_id	String	false
cpostal_id	String	false
poblacion_id	String	false
nielsen_id	String	false
clubvinos_id	long	false

Constraint Table Entries( row8 ):

Name	Type	Expression	isNullable

Mapper table Properties( row10 ):

Properties	Values
Name	row10
Matching-mode	UNIQUE_MATCH
isMinimized	false
isReject	false
isRejectInnerJoin	false
isInnerJoin	false

Metadata Table Entries( row10 ):

Name	Type	Expression	isNullable
cliente_id	long	row8.cliente_id	false
cliente_desc	String		false
agrupador_id	long		false
agrupador_desc	String		false
comercial_id	String		false
canal_id	int		false
canal_desc	String		false
tipocl_id	int		false
tipocl_desc	String		false
pais_id	String		false
region_id	String		false
provincia_id	String		false
cpostal_id	String		false
poblacion_id	String		false
nielsen_id	String		false
clubvinos_id	long		false

Constraint Table Entries( row10 ):

Name	Type	Expression	isNullable

Mapper table for tMap_2 ( output ):

Mapper table Properties( modificados ):

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

Metadata Table Entries( modificados ):

Name	Type	Expression	isNullable
cliente_id	long	row8.cliente_id	false
cliente_desc	String	row8.cliente_desc	false
agrupador_id	long	row8.agrupador_id	false
agrupador_desc	String	row8.agrupador_desc	false
comercial_id	String	row8.comercial_id	false
canal_id	int	row8.canal_id	false
canal_desc	String	row8.canal_desc	false
tipocl_id	int	row8.tipocl_id	false
tipocl_desc	String	row8.tipocl_desc	false
pais_id	String	row8.pais_id	false
region_id	String	row8.region_id	false
provincia_id	String	row8.provincia_id	false
cpostal_id	String	row8.cpostal_id	false
poblacion_id	String	row8.poblacion_id	false
nielsen_id	String	row8.nielsen_id	false
clubvinos_id	long	row8.clubvinos_id	false

Constraint Table Entries( modificados ):

Name	Type	Expression	isNullable

Mapper table Properties( modificados2 ):

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

Metadata Table Entries( modificados2 ):

Name	Type	Expression	isNullable
cliente_id	long	row8.cliente_id	false
cliente_desc	String	row8.cliente_desc	false
agrupador_id	long	row8.agrupador_id	false
agrupador_desc	String	row8.agrupador_desc	false
comercial_id	String	row8.comercial_id	false
canal_id	int	row8.canal_id	false
canal_desc	String	row8.canal_desc	false
tipocl_id	int	row8.tipocl_id	false
tipocl_desc	String	row8.tipocl_desc	false
pais_id	String	row8.pais_id	false
region_id	String	row8.region_id	false
provincia_id	String	row8.provincia_id	false
cpostal_id	String	row8.cpostal_id	false
poblacion_id	String	row8.poblacion_id	false
nielsen_id	String	row8.nielsen_id	false
clubvinos_id	long	row8.clubvinos_id	false

Constraint Table Entries( modificados2 ):

Name	Type	Expression	isNullable

Mapper table for tMap_2 ( 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

Component: tMysqlSCD

	UNIQUE NAME	tMysqlSCD_1	INPUT(S)	tReplicate_1
	LABEL	ACTUALIZA_DWD_CLIENTE_SCD	OUTPUT(S)	none

Component Parameters:

Properties	Values

Schema for tMysqlSCD_1 :

Column	Key	Type	Length	Nullable	Comment
agrupador_desc	false	String	40	false	Column generated by scd editor.
agrupador_id	false	long	10	false	Column generated by scd editor.
canal_desc	false	String	20	false	Column generated by scd editor.
canal_id	false	int	5	false	Column generated by scd editor.
cliente_desc	false	String	40	false	Column generated by scd editor.
cliente_id	false	long	10	false	Column generated by scd editor.
cliente_sk	true	int		false	Column generated by scd editor.
clubvinos_id	false	long	10	false	Column generated by scd editor.
comercial_id	false	String	20	false	Column generated by scd editor.
cpostal_id	false	String	10	false	Column generated by scd editor.
nielsen_id	false	String	10	false	Column generated by scd editor.
pais_id	false	String	15	false	Column generated by scd editor.
poblacion_id	false	String	35	false	Column generated by scd editor.
provincia_id	false	String	20	false	Column generated by scd editor.
region_id	false	String	20	false	Column generated by scd editor.
scd_end	false	java.util.Date		true	Column generated by scd editor.
scd_start	false	java.util.Date		false	Column generated by scd editor.
tipocl_desc	false	String	20	false	Column generated by scd editor.
tipocl_id	false	int	5	false	Column generated by scd editor.