{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"66ad48b3d4e4ba9609830d2c","instance_id":"1434084a-a62e-4d5f-bcdf-0524c8872e39","instance_version":4,"link_map":{"link106":{"dst_id":"2cacd924-2424-414a-9cfa-fd3c73d3f585","dst_view_id":"input0","src_id":"b59a40aa-b259-402f-a778-a78fb0d8eb22","src_view_id":"output0","isGoto":false},"link107":{"dst_id":"7695a12c-8489-4301-a97f-ea3b02ec8c51","dst_view_id":"inputRows","src_id":"2cacd924-2424-414a-9cfa-fd3c73d3f585","src_view_id":"output0","isGoto":false}},"link_serial":108,"property_map":{"info":{"label":{"value":"Oracle Parallel Load (with errors) Example"},"author":{"value":"admin@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"7695a12c-8489-4301-a97f-ea3b02ec8c51_error0":{"view_type":{"value":"document"},"label":{"value":"Oracle - Parallel Load - error0"}},"error_behavior":{"value":"none"}},"settings":{"error_pipeline":{"value":null,"expression":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"imports":{"value":[]}},"input":{},"output":{"7695a12c-8489-4301-a97f-ea3b02ec8c51_output101":{"label":{"value":"Oracle - Parallel Load - output0"},"view_type":{"value":"document"}}}},"render_map":{"scale_ratio":1,"pan_x_num":0,"pan_y_num":0,"default_snaplex":"61bceea5dff6bcbdfd713fcf","detail_map":{"b59a40aa-b259-402f-a778-a78fb0d8eb22":{"grid_x_int":2,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{},"output":{},"error":{}},"2cacd924-2424-414a-9cfa-fd3c73d3f585":{"grid_x_int":3,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"7695a12c-8489-4301-a97f-ea3b02ec8c51":{"grid_x_int":4,"grid_y_int":2,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0,"error":{"error0":{"rot_int":0,"dx_int":0,"dy_int":-1}}}}},"snap_map":{"b59a40aa-b259-402f-a778-a78fb0d8eb22":{"class_fqid":"com-snaplogic-snaps-transform-sequence_1-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-sequence","class_version":1,"instance_fqid":"b59a40aa-b259-402f-a778-a78fb0d8eb22_1","instance_id":"b59a40aa-b259-402f-a778-a78fb0d8eb22","instance_version":1,"property_map":{"info":{"label":{"value":"Sequence"},"notes":{}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"execution_mode":{"value":"Validate & Execute"},"initialValueProp":{"value":1,"expression":false},"stepValueProp":{"value":1,"expression":false},"numberOfDocumentsProp":{"value":1000,"expression":false},"passThroughProp":{"value":false}},"view_serial":100,"input":{}},"class_build_tag":"SNAPSHOT"},"2cacd924-2424-414a-9cfa-fd3c73d3f585":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"2cacd924-2424-414a-9cfa-fd3c73d3f585_2","instance_id":"2cacd924-2424-414a-9cfa-fd3c73d3f585","instance_version":2,"property_map":{"info":{"label":{"value":"Mapper"},"notes":{}},"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"settings":{"maxThreadCountProp":{"value":0,"expression":false},"stepValueProp":{"value":1,"expression":false},"execution_mode":{"value":"Validate & Execute"},"transformations":{"value":{"mappingRoot":{"value":"$"},"mappingTable":{"value":[{"expression":{"expression":true,"value":"$value % 250 == 0 || $value == 25 || $value == 26 || $value == 30 ? 'Invalid ID' : $value"},"targetPath":{"value":"$SUBSCRIBER_ID"}},{"expression":{"value":"Date.parse(\"2024-08-02T06:06:09.123456789\")","expression":true},"targetPath":{"value":"$SUBSCRIBER_LAST_LOGIN"}},{"expression":{"value":"$value % 3 == 0 ? \"James Witters\" : ($value % 3 == 1 ? 'Allison Claeys' : 'Ben Park' )","expression":true},"targetPath":{"value":"$SUBSCRIBER_FULL"}}]}}},"schemaName":{"value":null,"expression":false},"maxErrorCountProp":{"value":50,"expression":false},"initialValueProp":{"value":1,"expression":false},"createTable":{"value":false},"preloadTruncateProp":{"value":false,"expression":false},"passThrough":{"value":false},"passThroughProp":{"value":false},"batchCapacityProp":{"value":1000,"expression":false},"nullSafeAccess":{"value":false},"tableName":{"value":null,"expression":false},"numberOfDocumentsProp":{"value":1,"expression":false}},"view_serial":100},"class_build_tag":"SNAPSHOT"},"7695a12c-8489-4301-a97f-ea3b02ec8c51":{"class_fqid":"com-snaplogic-snaps-oracle-bulkloadhighperformance_1-SNAPSHOT","class_id":"com-snaplogic-snaps-oracle-bulkloadhighperformance","class_version":1,"instance_fqid":"7695a12c-8489-4301-a97f-ea3b02ec8c51_2","instance_id":"7695a12c-8489-4301-a97f-ea3b02ec8c51","instance_version":2,"property_map":{"info":{"label":{"value":"Oracle - Parallel Load"},"notes":{}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"settings":{"maxThreadCountProp":{"value":4,"expression":false},"stepValueProp":{"value":1,"expression":false},"execution_mode":{"value":"Validate & Execute"},"schemaName":{"value":"\"TECTONIC\"","expression":false},"maxErrorCountProp":{"value":50,"expression":false},"initialValueProp":{"value":1,"expression":false},"createTable":{"value":true},"preloadTruncateProp":{"value":true,"expression":false},"passThroughProp":{"value":false},"batchCapacityProp":{"value":100,"expression":false},"tableName":{"value":"\"TECTONIC\".\"SUBSCRIBERS\"","expression":false},"executable_during_suggest":{"value":false},"numberOfDocumentsProp":{"value":1,"expression":false}},"account":{"account_ref":{"value":{"label":{"value":"Oracle DB account","label":"Oracle DB account","expression":false},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-oraclethindatabaseaccount"},"ref_id":{"value":"3216a88a-626e-4ca0-9252-03a76e7f22ad","expression":false}}}},"view_serial":101,"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"}},"path_id":"/snaplogic/projects/shared","path_snode":"61bcee93f0182bf4410c98de","target_runtime":"standard"}