I have a SQL statement that involves a self-join and and an inner join with a second table. It is something like this:
tableA and tableB are flat file sources. What is the best design approach for implementing this pattern in SPL.
I looked at SPL Join and DynamicFilter and Map operators. SQL assumes all data in tableA and tableB are available before processing whereas SPL operates on incoming tuples. No sure about the approach.
Any guidance would be helpful.