user_merge
Normal
0
/
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD
ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD
0.0
0.0
10000
50
50
N
Y
50000
Y
N
1000
100
-
2011/07/12 15:06:21.049
-
2011/07/12 15:06:21.049
EC2 MSSQL
174.129.247.34
MSSQL
Native
fivesenses
1433
sa
Encrypted 2be989bfa0fc986a9a417bd64db80f782
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1433
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
Local MySQL
localhost
MYSQL
Native
etl
3306
root
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
Y
USE_POOLING
N
RDS Prod
survivalcode-prod-db.cfc9iwc5iia4.us-east-1.rds.amazonaws.com
MYSQL
Native
five_prod
3306
admin
Encrypted 2be98afc86aa7f280a41aba7fcc85a7d5
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
RDS Stage
survivalcode-stage-db.cfc9iwc5iia4.us-east-1.rds.amazonaws.com
MYSQL
Native
five_staging
3306
admin
Encrypted 2be98afc86aa7f2e4b80daf62c993bdc9
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
Y
USE_POOLING
N
Sort rows Merge Join Y Sort rows 2 Merge Join Y Sort rows 3 Merge Join 2 Y Merge Join 2 Select values 4 Y Value Mapper Value Mapper 2 Y Value Mapper 2 Value Mapper 2 2 Y Value Mapper 2 2 Value Mapper 2 2 2 Y Value Mapper 2 2 2 Value Mapper 2 2 2 2 Y Value Mapper 2 2 2 2 Value Mapper 2 2 2 2 2 Y Value Mapper 2 2 2 2 2 Select values 3 Y Merge Join Select values 5 Y Select values 5 Sort rows 4 Y Sort rows 4 Merge Join 2 Y AWS ftl_users Value Mapper Y AWS Users Select values Y Select values 2 String operations Y Select values String operations 2 Y String operations 2 Sort rows 2 Y Select values 3 String operations 3 Y String operations 3 Sort rows 3 Y String operations Sort rows Y AWS Membership Value Mapper 3 Y Value Mapper 3 Select values 2 Y Passwords String operations 4 Y String operations 4 Text file output Y Photos String operations 4 2 Y String operations 4 2 Text file output 2 Y Select values 4 Insert / Update stage Y
AWS Membership
TableInput
Y
1
none
EC2 MSSQL
SELECT
UserId
, Password
, Email
, IsApproved
, IsLockedOut
, CreateDate
, LastLoginDate
, LastPasswordChangedDate
, LastLockoutDate
, FailedPasswordAttemptCount
, FailedPasswordAttemptWindowStart
, FailedPasswordAnswerAttemptCount
, FailedPasswordAnswerAttemptWindowStart
FROM aspnet_Membership
0
N
N
N
112
75
Y
AWS Users
TableInput
Y
1
none
EC2 MSSQL
SELECT
UserId
, UserName
, LastActivityDate
FROM aspnet_Users
0
N
N
N
113
158
Y
AWS ftl_users
TableInput
Y
1
none
EC2 MSSQL
SELECT
userid
, firstname
, lastname
, phone
, street
, city
, country
, "STATE"
, zip
, ip
, timezone
, age
, dob
, unsubscribe
, bounced
, emailok
, postmailok
, phonecallok
, textok
, hasuserphoto
FROM rep_ftl_users
0
N
N
N
114
236
Y
Insert / Update local
InsertUpdate
Y
1
none
Local MySQL
100
N
guid
guid
=
guid
guid
N
firstname
firstname
N
lastname
lastname
N
phone
phone
N
addr1
addr1
N
city
city
N
country
country
N
state
STATE
N
zip
zip
N
last_sign_in_ip
last_sign_in_ip
N
time_zone
time_zone
N
age
age
N
dob
dob
N
unsubscribe
unsubscribe
N
bounced
bounced
N
emailok
emailok
N
postmailok
postmailok
N
phonecallok
phonecallok
N
textok
textok
N
has_user_photo
has_user_photo
N
email
email
N
is_locked_out
is_locked_out
N
created_at
created_at
N
last_sign_in_at
last_sign_in_at
N
last_password_changed_date
last_password_changed_date
N
last_lockout_date
last_lockout_date
N
failed_password_attempt_count
failed_password_attempt_count
N
failed_password_attempt_window_start
failed_password_attempt_window_start
N
failed_password_answer_attempt_count
failed_password_answer_attempt_count
N
failed_password_answer_attempt_window_start
failed_password_answer_attempt_window_start
N
username
username
N
last_activity_date
last_activity_date
N
confirmed_at
confirmed_at
N
1004
140
Y
Merge Join
MergeJoin
Y
1
none
INNER
Sort rows
Sort rows 2
guid
guid
625
118
Y
Merge Join 2
MergeJoin
Y
1
none
INNER
Sort rows 4
Sort rows 3
guid
guid
842
174
Y
Passwords
TableInput
Y
1
none
EC2 MSSQL
SELECT
rep_ftl_users.userid, rtrim(ltrim(rep_ftl_users.clearpassword))
FROM
rep_ftl_users
0
N
N
N
114
309
Y
Photos
TableInput
Y
1
none
EC2 MSSQL
SELECT
userid
, originalphotofilename
FROM rep_badge_Badges
0
N
N
N
114
379
Y
Select values
SelectValues
Y
1
none
UserName
username
-2
-2
UserId
guid
-2
-2
LastActivityDate
last_activity_date
-2
-2
N
368
158
Y
Select values 2
SelectValues
Y
1
none
Email
email
-2
-2
UserId
guid
-2
-2
IsLockedOut
is_locked_out
-2
-2
CreateDate
created_at
-2
-2
LastLoginDate
last_sign_in_at
-2
-2
LastPasswordChangedDate
last_password_changed_date
-2
-2
LastLockoutDate
last_lockout_date
-2
-2
FailedPasswordAttemptCount
failed_password_attempt_count
-2
-2
FailedPasswordAttemptWindowStart
failed_password_attempt_window_start
-2
-2
FailedPasswordAnswerAttemptCount
failed_password_answer_attempt_count
-2
-2
FailedPasswordAnswerAttemptWindowStart
failed_password_answer_attempt_window_start
-2
-2
confirmed_at
-2
-2
N
confirmed_at
confirmed_at
Date
-2
-2
false
373
75
Y
Select values 3
SelectValues
Y
1
none
userid
guid
-2
-2
firstname
-2
-2
lastname
-2
-2
phone
-2
-2
street
addr1
-2
-2
city
-2
-2
country
-2
-2
state
-2
-2
zip
-2
-2
ip
last_sign_in_ip
-2
-2
timezone
time_zone
-2
-2
age
-2
-2
dob
-2
-2
unsubscribe
-2
-2
bounced
-2
-2
emailok
-2
-2
postmailok
-2
-2
phonecallok
-2
-2
textok
-2
-2
hasuserphoto
has_user_photo
-2
-2
N
emailok
emailok
Integer
1
-2
false
phonecallok
phonecallok
Integer
1
-2
false
postmailok
postmailok
Integer
1
-2
false
textok
textok
Integer
1
-2
false
bounced
bounced
Integer
1
-2
false
unsubscribe
unsubscribe
Integer
1
-2
false
626
236
Y
Select values 4
SelectValues
Y
1
none
guid
-2
-2
firstname
-2
-2
lastname
-2
-2
phone
-2
-2
addr1
-2
-2
city
-2
-2
country
-2
-2
state
-2
-2
zip
-2
-2
last_sign_in_ip
-2
-2
time_zone
-2
-2
age
-2
-2
dob
-2
-2
unsubscribe
-2
-2
bounced
-2
-2
emailok
-2
-2
postmailok
-2
-2
phonecallok
-2
-2
textok
-2
-2
has_user_photo
-2
-2
email
-2
-2
confirmed_at
-2
-2
is_locked_out
-2
-2
created_at
-2
-2
last_sign_in_at
-2
-2
last_password_changed_date
-2
-2
last_lockout_date
-2
-2
failed_password_attempt_count
-2
-2
failed_password_attempt_window_start
-2
-2
failed_password_answer_attempt_count
-2
-2
failed_password_answer_attempt_window_start
-2
-2
username
-2
-2
last_activity_date
-2
-2
N
918
174
Y
Select values 5
SelectValues
Y
1
none
email
-2
-2
guid
-2
-2
is_locked_out
-2
-2
created_at
-2
-2
last_sign_in_at
-2
-2
last_password_changed_date
-2
-2
last_lockout_date
-2
-2
failed_password_attempt_count
-2
-2
failed_password_attempt_window_start
-2
-2
failed_password_answer_attempt_count
-2
-2
failed_password_answer_attempt_window_start
-2
-2
username
-2
-2
last_activity_date
-2
-2
confirmed_at
-2
-2
N
698
118
Y
Sort rows
SortRows
Y
1
none
%%java.io.tmpdir%%
out
1000000
N
N
guid
Y
N
545
75
Y
Sort rows 2
SortRows
Y
1
none
%%java.io.tmpdir%%
out
1000000
N
N
guid
Y
N
546
158
Y
Sort rows 3
SortRows
Y
1
none
%%java.io.tmpdir%%
out
1000000
N
N
guid
Y
N
771
236
Y
Sort rows 4
SortRows
Y
1
none
%%java.io.tmpdir%%
out
1000000
N
N
guid
Y
N
771
118
Y
String operations
StringOperations
Y
1
none
guid
none
lower
none
no
none
none
none
email
none
lower
none
no
none
none
none
470
75
Y
String operations 2
StringOperations
Y
1
none
guid
none
lower
none
no
none
none
none
460
158
Y
String operations 3
StringOperations
Y
1
none
guid
none
lower
none
no
none
none
none
699
236
Y
String operations 4
StringOperations
Y
1
none
userid
none
lower
none
no
none
none
none
clearpassword
both
none
none
no
none
none
none
529
309
Y
String operations 4 2
StringOperations
Y
1
none
userid
none
lower
none
no
none
none
none
originalphotofilename
both
none
none
no
none
none
none
529
379
Y
Table output
TableOutput
Y
1
none
Local MySQL
1000
N
N
Y
N
N
N
Y
N
Y
N
username
username
guid
guid
last_activity_date
last_activity_date
email
email
is_approved
is_approved
is_locked_out
is_locked_out
created_at
created_at
last_sign_in_at
last_sign_in_at
last_password_changed_date
last_password_changed_date
last_lockout_date
last_lockout_date
failed_password_attempt_count
failed_password_attempt_count
failed_password_attempt_window_start
failed_password_attempt_window_start
failed_password_answer_attempt_count
failed_password_answer_attempt_count
failed_password_answer_attempt_window_start
failed_password_answer_attempt_window_start
883
49
Y
Text file output
TextFileOutput
Y
1
none
,
"
N
N
DOS
None
N
/tmp/passwords
N
N
txt
N
N
N
N
N
N
Y
N
N
0
1008
309
Y
Text file output 2
TextFileOutput
Y
1
none
,
"
N
N
DOS
None
N
/tmp/photos
N
N
txt
N
N
N
N
N
N
Y
N
N
0
1011
379
Y
Value Mapper
ValueMapper
Y
1
none
unsubscribe
N
Y
1
N
0
358
236
Y
Value Mapper 2
ValueMapper
Y
1
none
bounced
N
Y
1
N
0
397
236
Y
Value Mapper 2 2
ValueMapper
Y
1
none
emailok
N
Y
1
N
0
437
236
Y
Value Mapper 2 2 2
ValueMapper
Y
1
none
postmailok
N
Y
1
N
0
476
236
Y
Value Mapper 2 2 2 2
ValueMapper
Y
1
none
phonecallok
N
Y
1
N
0
515
236
Y
Value Mapper 2 2 2 2 2
ValueMapper
Y
1
none
textok
N
Y
1
N
0
554
236
Y
Value Mapper 3
ValueMapper
Y
1
none
IsApproved
confirmed_at
Y
2011/07/01 22:22:22.222
285
75
Y
Insert / Update stage
InsertUpdate
Y
1
none
RDS Stage
100
N
guid
guid
=
guid
guid
N
firstname
firstname
N
lastname
lastname
N
phone
phone
N
addr1
addr1
N
city
city
N
country
country
N
state
STATE
N
zip
zip
N
last_sign_in_ip
last_sign_in_ip
N
time_zone
time_zone
N
age
age
N
dob
dob
N
unsubscribe
unsubscribe
N
bounced
bounced
N
emailok
emailok
N
postmailok
postmailok
N
phonecallok
phonecallok
N
textok
textok
N
has_user_photo
has_user_photo
N
email
email
N
is_locked_out
is_locked_out
N
created_at
created_at
N
last_sign_in_at
last_sign_in_at
N
last_password_changed_date
last_password_changed_date
N
last_lockout_date
last_lockout_date
N
failed_password_attempt_count
failed_password_attempt_count
N
failed_password_attempt_window_start
failed_password_attempt_window_start
N
failed_password_answer_attempt_count
failed_password_answer_attempt_count
N
failed_password_answer_attempt_window_start
failed_password_answer_attempt_window_start
N
username
username
N
last_activity_date
last_activity_date
N
confirmed_at
confirmed_at
N
1007
76
Y
Insert / Update prod
InsertUpdate
Y
1
none
RDS Prod
100
N
guid
guid
=
guid
guid
N
firstname
firstname
N
lastname
lastname
N
phone
phone
N
addr1
addr1
N
city
city
N
country
country
N
state
STATE
N
zip
zip
N
last_sign_in_ip
last_sign_in_ip
N
time_zone
time_zone
N
age
age
N
dob
dob
N
unsubscribe
unsubscribe
N
bounced
bounced
N
emailok
emailok
N
postmailok
postmailok
N
phonecallok
phonecallok
N
textok
textok
N
has_user_photo
has_user_photo
N
email
email
N
is_locked_out
is_locked_out
N
created_at
created_at
N
last_sign_in_at
last_sign_in_at
N
last_password_changed_date
last_password_changed_date
N
last_lockout_date
last_lockout_date
N
failed_password_attempt_count
failed_password_attempt_count
N
failed_password_attempt_window_start
failed_password_attempt_window_start
N
failed_password_answer_attempt_count
failed_password_answer_attempt_count
N
failed_password_answer_attempt_window_start
failed_password_answer_attempt_window_start
N
username
username
N
last_activity_date
last_activity_date
N
confirmed_at
confirmed_at
N
1008
219
Y
MySQL Bulk Loader
MySQLBulkLoader
Y
1
none
Local MySQL
"
\
Y
N
/tmp/fifo
guid
guid
OK
1004
24
Y
N