IAM Works

This document explains how to onboard JDBC as an Authoritative with Delta Aggregation In this example I am using Oracle MySQL as database server Create HR Source database, source table, delta table, triggers Create new database create database hrdatabase; use hrdatabase; Create hrsource table create table hrsource (    employeeNumber varchar(255), firstName varchar(255),    lastName varchar(255), userType varchar(255),    personalEmail varchar(255), department varchar(255), city varchar(255), manager varchar(255), status varchar(255), PRIMARY KEY (employeeNumber) ); Insert few records( for testing full aggregation ) insert into hrsource values('1001','Ravi','Kumar','E','ravikumar@gmail.com','Development','Bangalore','','A'); insert into hrsource values('1002','Jayanth','G','E','jayanth.g@gmail.com...

Below query gives you user XXXXXX record and XXXXXX manager records ie total 2 rows from the table hr_source select hrview.userName,hrview.firstName,hrview.lastName,hrview.email,hrview.employeeNumber,hrview.supervisor from hr_source hrview where hrview.employeeNumber in( select hrview1.supervisor from hr_source hrview1 WHERE hrview1.userName='XXXXXX' ) UNION select hrview1.userName,hrview1.firstName,hrview1.lastName,hrview1.email,hrview1.employeeNumber,hrview1.supervisor from hr_source hrview1 WHERE hrview1.userName='XXXXXX'