I have a requirement to create an AJI (Partitioned on Shipment_Dt) with 120 Weeks of Data. Could you please suggest the best way to implement that based on your experiences.
1. Keep the dimension Ids and their Descriptions in the AJI along with the Fact Metrics. This will make sure that majority of the Analytical queries accessing the dimansion Descriptions use the AJI. The downside is if the name/Desc of the Dimansion Id changes, it will update the AJI everytime for all the 120 Weeks which will take a lot of time.
2. Keep only the dimension Ids in the AJI along with the Fact Metrics. This AJI should not be updated everytime a the name/Desc changes in the domensions as its transparent to the AJI since the IDs don't change. Will this approach always use the AJIs when a user want to report on the Dimension names and not IDs ?