{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"66ad3242c9b4467f86f43376","instance_id":"e05a2196-1771-44b6-9cb5-d64fa894956f","instance_version":36,"link_map":{"link106":{"dst_id":"957134ac-94b6-4458-9f11-095f15082515","dst_view_id":"input0","src_id":"a5b9ab79-4c2b-4488-8453-6de828b911d3","src_view_id":"output0","isGoto":false},"link107":{"dst_id":"76ec6f5c-a571-434f-a51b-05e98bd22696","dst_view_id":"inputRows","src_id":"957134ac-94b6-4458-9f11-095f15082515","src_view_id":"output0","isGoto":false}},"link_serial":108,"property_map":{"info":{"label":{"value":"Oracle Parallel Load Example"},"author":{"value":"admin@snaplogic.com"},"pipeline_doc_uri":{"value":null},"notes":{"value":null},"purpose":{"value":null}},"error":{"76ec6f5c-a571-434f-a51b-05e98bd22696_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":{"76ec6f5c-a571-434f-a51b-05e98bd22696_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":{"a5b9ab79-4c2b-4488-8453-6de828b911d3":{"grid_x_int":2,"grid_y_int":3,"rot_int":0,"recommendation_id":null,"source":"snap catagory","index":null,"rot_tail_int":0,"input":{}},"957134ac-94b6-4458-9f11-095f15082515":{"grid_x_int":3,"grid_y_int":3,"rot_int":0,"recommendation_id":null,"source":"","index":null,"rot_tail_int":0},"76ec6f5c-a571-434f-a51b-05e98bd22696":{"grid_x_int":4,"grid_y_int":3,"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":{"a5b9ab79-4c2b-4488-8453-6de828b911d3":{"class_fqid":"com-snaplogic-snaps-transform-sequence_1-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-sequence","class_version":1,"instance_fqid":"a5b9ab79-4c2b-4488-8453-6de828b911d3_5","instance_id":"a5b9ab79-4c2b-4488-8453-6de828b911d3","instance_version":5,"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"},"957134ac-94b6-4458-9f11-095f15082515":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"957134ac-94b6-4458-9f11-095f15082515_4","instance_id":"957134ac-94b6-4458-9f11-095f15082515","instance_version":4,"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"},"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"},"76ec6f5c-a571-434f-a51b-05e98bd22696":{"class_fqid":"com-snaplogic-snaps-oracle-bulkloadhighperformance_1-SNAPSHOT","class_id":"com-snaplogic-snaps-oracle-bulkloadhighperformance","class_version":1,"instance_fqid":"76ec6f5c-a571-434f-a51b-05e98bd22696_5","instance_id":"76ec6f5c-a571-434f-a51b-05e98bd22696","instance_version":5,"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":"Execute only"},"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"}