For joining the data from 2 different kafka topics based on a column which is present in both topics and then populating the data on to 3rd topic what is preferable Kstreams or KSQL
Either - it depends if you want to write SQL or Java 
Here’s a useful discussion: Kafka Streams vs. ksqlDB for Stream Processing | UK
2 Likes