08-22-2018 11:44 AM
Created by @dkifle
This pipeline pattern is used to read records of student information and lookup and compile the address of each student based on whether or not the student is a domestic or international student.
Sources: CSV data, Oracle, SQL Server (CSV Generator can be replaced by any student information system.)
Targets: Oracle and Redshift tables
Snaps used: CSV Generator, Router, Oracle and SQL Server Lookup, Mapper, Union, Copy, Oracle Merge, Redshift Insert
Look Up Student Address.slp (19.0 KB)