Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My requirement is to create additional aggregates tables on the basis of existing table column in datawarehouse.For this I have created aggregated table in datamart as we have a feature to use in Datamart. The problem with aggregated mart is it doesnt't support incremtal load . We always have to do a full load instead. And my data is already loaded in the datawarehouse and it is in huge amount in crores. So for every time it is not feasible to do a full load.
Is there any work arround so we can create an aggregation table and can load data incrementally?
Thankyou for sharing. i will use Oracle functions.