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.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Loading data from multiple CSV files into two Oracle tables

smudassir
Employee
Employee

‎07-25-2018 01:49 PM

Contributed by @smudassir

This pipeline pattern reads multiple CSV files containing student grades, parses these CSV files into CSV records and inserts these records into two Oracle tables separating the passed and failed grades, including timestamp.
Load%20Students%20Marks%20from%20Multiple%20Files%20into%20Two%20Oracle%20Tables%20based%20on%20Passed%20or%20Failed

The pipeline pattern can be configured to meet similar use cases for other industries. For example, sales and marketing can use this pipeline pattern to segment their opportunities, hot/cold leads, loyal customers for targeted sales and marketing campaigns.

Source: CSV files uploaded to the SnapLogic Database
Target: Oracle Database Thin Connection
Snaps Used: Multi-file Reader, CSV Parser, Mapper, Router, Oracle Insert

Downloads

Load Students Marks from Multiple Files into Two Oracle Tables based on Passed or Failed_2018_06_28.... (10.6 KB)

Sample files for used with this pipeline. Unzip the files and upload them to your project.
CSV Files.zip (2.7 KB)

Load Students Marks from Multiple Files into Two Oracle Tables based on Passed or Failed_2018_06_28.slp
CSV Files.zip
0 Kudos
Reply
0 REPLIES 0