Is there any reason you cannot just do a big SELECT w/ multiple joins? From your comment it sounds like you're trying to fetch all four tables and then join them with NiFi instead of having Oracle do it for you.
On Wed, Feb 21, 2018 at 10:56 AM, sridharan m <[email protected]> wrote: > hi team, > i am trying to retrieve more than 4 tables from the rdbms oracle > database and i need to join all the tables and have to send it to the nosql > database like cassandra or mongo or hive.... currently i am using apache > nifi for this approach but i cannot able to join the tables still all the > tables has same ID as the unique key.... using that and also when inserting > in the flat table of nosql it produces duplicate records. so guys if u have > any idea in doing this job. please help me to solve this issue. > > project goal : > oracle database tables should be joined and which should be collected > and stored in nosql database in realtime. > > > thanks, > Sridharan.M > mobile : +918040206980 > skype : sri6100 >
