Ravi Kommuri wrote:Thank you Jayesh A Lalwani.
All 1.5 Cr Transaction are individual , A single Transaction do some calculation on data(which is taken from other master tables and reform) and insert one more records in 4-5 tables and there will be some updations too.
each transaction a unique configurable id will be generated. and this should not be missed.. let say a transaction id is abc1 the next one should be abc2... abcxxx. i guess even in parallel processing this is not a problem.
Thank again for advising some frameworks . first we go through Apache Hadoop so me might get some information on how to start.