Am working on a Billing EXTRACTing report, in this system approximately 1,000 invoices will be created per day.
After filtering the selection as per user selection criteria, approximately 200 (per day) invoices will be seleted by my report, but, functional guy(business analyst) is asking me to insert all these 200 per day into a Z table (say log table). But, am thinking it's not a good practise!! because adding/log these 200 entries per day to a Z table, dont know How big this Z table will become after 1 year!!
So, pls. suggest me Is there any other way/idea to get resolved this requirement?