I have 6 lakh DB records to read from SQL server at a given time.
From DB, data file & control file need to be picked up, combine based on data and should be sent to one DB.
What are the performance factors involved ?
How long does the processing may take?
What is the suggested system resources for this?
What is the guarantee of the message processing?
If anyone has faced this problem earlier, do let me know can PI handle such load?
Thanks,
Venkat.