My question is in the Telecom Domain.
Suppose a number of 10 million subscribers are to be disbursed with a campaign on 1st Jan .But the IN system in this case supports a maximum of 3 million user per day.
So the 10 Million subscribers are to be split into 3,3,3,1 million users on consecutive days.
In Oracle terms these are the input and desired output
10 million 1st Jan
This need s to be split into
3 million 1st Jan
3 million 2nd Jan
3 million 3rd Jan
1 million 4th Jan
I have been able to do an equal division i.e. my output is like this
2.5 million 1st Jan
2.5 million 2nd Jan
2.5 million 3rd Jan
2.5 million 4th Jan
But how do I get the first output which is required by the client
Thanks in Advance
Know more about SAP Oracle