Hi,
I am new to transformer. we have incremental delta data load into our db2 db. we have already existing power cubes, what we need to do for updating/rebuilding the cubes after the delta data load.
Regards,
Nagesh
Generally speaking, you can simply rebuild the cube.
If you want to incrementally update the cube, you can do it but there are some caveats and steps to take before you deploy. This is covered in the Transformer user guide.
http://www-01.ibm.com/support/knowledgecenter/api/content/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cogtr.10.2.1.doc/c_maintainmodelscubes.html#maintainmodelscubes (http://www-01.ibm.com/support/knowledgecenter/api/content/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cogtr.10.2.1.doc/c_maintainmodelscubes.html#maintainmodelscubes)
How many date dimsions are you going to require?
If you only have one Date Dimension, then I would reccomend a Time based Partion Cube build process over the tradtional incremental cube build process. Time based partition cube does not require a complete rebuild like a incremental does every x number of builds. One reason is because builds seperate cubes for the incremental updates after your intial cube build but the user only sees the solution as one cube. how many cubes/increcments you maintain can be controlled by a vsd file, which references each of the cubes and you can build a script to delete records out of the file. Anyway I am throwing a lot at you but, point is if you are only using one date dimension in your model, then you should consider using a Time based partition cube. You can find out more information on it in the transformer user guide, which is free to access, just google it.
Thanks
Charlie