I have 2 table Table1(ID, Name) and Table2 (ID, Email). Table1 is added to Golde Gate to capture any change (insert /update /delete) and put it in a trail file and then Golden Gate for Big Data read the trail file and send it to Kafka. If for example there is a change in Name in Table1, we need to send 3 columns (ID, Name, Email) to Kafka. From first Table Table1 Golden Gate will capture (ID, Name) and we need to get for same ID the email from the second Table Table2 and send the 3 columns ID, Name, Email to Kafka .