currency_rate
Normal
/
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDTRANSNAMEYTRANSNAMESTATUSYSTATUSLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSSTARTDATEYSTARTDATEENDDATEYENDDATELOGDATEYLOGDATEDEPDATEYDEPDATEREPLAYDATEYREPLAYDATELOG_FIELDYLOG_FIELD
ID_BATCHYID_BATCHSEQ_NRYSEQ_NRLOGDATEYLOGDATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSINPUT_BUFFER_ROWSYINPUT_BUFFER_ROWSOUTPUT_BUFFER_ROWSYOUTPUT_BUFFER_ROWS
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATELOGGING_OBJECT_TYPEYLOGGING_OBJECT_TYPEOBJECT_NAMEYOBJECT_NAMEOBJECT_COPYYOBJECT_COPYREPOSITORY_DIRECTORYYREPOSITORY_DIRECTORYFILENAMEYFILENAMEOBJECT_IDYOBJECT_IDOBJECT_REVISIONYOBJECT_REVISIONPARENT_CHANNEL_IDYPARENT_CHANNEL_IDROOT_CHANNEL_IDYROOT_CHANNEL_ID
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSLOG_FIELDNLOG_FIELD
0.0
0.0
10000
50
50
N
Y
50000
Y
N
1000
100
-
2012/12/28 16:39:35.971
-
2012/12/28 16:39:35.971
source
${source_host}
POSTGRESQL
Native
${source}
${source_port}
${source_user}
${source_password}
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
${source_port}
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
target
${target_host}
POSTGRESQL
Native
${target}
${target_port}
${target_user}
${target_password}
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
${target_port}
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
USE_POOLING
N
Table inputsourceN targetTable outputN Select valuesTable outputN Select valuestargetY currencySelect valuesY sourcecreate_uidY create_uidwrite_uidY write_uidcurrencyY
Select values
SelectValues
N
1
none
N
create_uid
write_uid
target_currency
currency
Integer
-2
-2
false
create_uid_target
create_uid
Integer
-2
-2
false
write_uid_target
write_uid
Integer
-2
-2
false
name
date
Date
-2
-2
false
540
207
Y
Table input
TableInput
Y
1
none
source
SELECT * FROM res_currency_rate
0
N
N
N
119
316
Y
Table output
TableOutput
Y
1
none
target
public
1000
N
N
N
N
N
N
Y
N
Y
N
646
326
Y
create_uid
DBLookup
Y
4
none
target
Y
Y
0
migration
N
N
create_uid
source
=
target
create_uid_target
Integer
225
207
Y
currency
DBLookup
N
1
none
target
Y
N
0
migration
currency_currency_mapping
N
N
currency_id
source
=
target
target_currency
Integer
435
207
Y
source
Dummy
Y
1
none
120
207
Y
target
Dummy
Y
1
none
645
207
Y
write_uid
DBLookup
Y
4
none
target
Y
Y
0
migration
N
N
write_uid
source
=
target
write_uid_target
Integer
330
207
Y
N