BPMonk
asked on
List or Range Partitioning
Hi Yall.
Every month a flatfile approx 500mb will be loaded into a Finance Oracle Datamart via Informatica. The requirements are to keep 24 periods of data. I would have said Range partitioning was the best Partitionign strategy but one could also have List as P1,P2,P3 etc. Ive written a SP to accomodate both but wonder what would be the best strategy ?
Regards
Ben
Every month a flatfile approx 500mb will be loaded into a Finance Oracle Datamart via Informatica. The requirements are to keep 24 periods of data. I would have said Range partitioning was the best Partitionign strategy but one could also have List as P1,P2,P3 etc. Ive written a SP to accomodate both but wonder what would be the best strategy ?
Regards
Ben
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.