Transformation 1
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
-
2011/07/01 12:38:54.236
-
2011/07/01 12:38:54.236
Local MySQL
localhost
MYSQL
Native
tst_kettle_data
3306
pentaho_user
Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
IS_CLUSTEREDN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
SUPPORTS_BOOLEAN_DATA_TYPEN
USE_POOLINGN
SIS Dev
17.3.120.25
MYSQL
Native
tst_kettle_data
3306
pentaho_user
Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
IS_CLUSTEREDN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
SUPPORTS_BOOLEAN_DATA_TYPEN
USE_POOLINGN
SIS Repo
17.3.120.25
MYSQL
Native
tst_kettle
3306
pentaho_user
Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
IS_CLUSTEREDN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
SUPPORTS_BOOLEAN_DATA_TYPEN
USE_POOLINGN
Data GridSort rowsY Sort rowsUnique rowsY Unique rowsAdd sequenceY Add sequenceMerge JoinY Merge JoinRemove duplicate fieldsY Unique rowsMerge JoinY Add sequenceMerge both streamsY Remove duplicate fieldsMerge both streamsY
Sort rows
SortRows
Y
1
none
%%java.io.tmpdir%%
out
1000000
N
N
value
Y
N
192
133
Y
Data Grid
DataGrid
Y
1
none
pk1
Integer
-1
-1
pk2
String
-1
-1
value
Integer
-1
-1
- 1
- A
- 4
- 1
- B
- 6
- 1
- C
- 3
- 1
- D
- 10
- 2
- A
- 10
- 2
- B
- 3
- 2
- C
- 7
- 2
- D
- 5
- 3
- A
- 5
- 3
- B
- 5
- 3
- C
- 10
- 3
- D
- 6
- 4
- A
- 2
- 4
- B
- 8
- 4
- C
- 3
- 4
- D
- 6
61
132
Y
Unique rows
Unique
N
1
none
N
Y
value
N
309
134
Y
Add sequence
Sequence
N
1
none
rank
N
SEQ_
Y
1
1
999999999
468
99
Y
Merge Join
MergeJoin
Y
1
none
INNER
Unique rows
Add sequence
value
value
603
174
Y
Remove duplicate fields
SelectValues
Y
1
none
N
pk1_1
pk2_1
value_1
739
173
Y
Merge both streams
Dummy
Y
1
none
905
99
Y
Unique rows
Merge Join
Y
N