This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Step 1: use openssl to create a new AES key. Below is an example of a command and the result. The iv string can be copy and pasted into the Initialization vector field of an AES encryption/decryption snap.
$ openssl enc -aes-256-cbc -base64 -k sec...
Sharding a table is a type of partitioning that separates very large table the into smaller parts for loading data in parallel into target system.
For Performance improvement the table was partitioned into multiple parts with Shard Offset snap and tr...
How to generate a unique sequence number
It’s very simple to generate a unique sequence number on each document being processed through a snap. Below is the screen shot and attached is the sample pipeline.
Sequence_2017_02_18.slp (2.8 KB)
How to group a set of number of records into a JSON list?
It’s very simple to prepare the data into smaller groups with specific number of records in each list by specificfying it’s group size on the snap. Below is the quick screen shot of the config...
How to convert Json list to Array
It’s very simple to covert JSON list to Array in SnapLogic.
Simply drag and drop the Snap “Json Splitter” and connect to any document format snap whose downstream is a JSON list like in the attached example, select t...
