Look up addresses from multiple databases

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.

Configuration

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

Downloads

Look Up Student Address.slp (19.0 KB)