Skip to Content
Former Member
Jan 03, 2006 at 09:48 PM

Enhance Datamart Extract Structure? Possible?


Is it possible to Enhance the Datamart Extract structure and add new fields at the end and populate them with custom code?

This is related to one of my previous questions. I have to merge the data from 2 ODS's into one Cube where in addition to loading the data from the 2 ODS separately into the Cube, I have to load data from some of the columns of ODS2 in ODS1 lines and vice versa. As of now I am doing this using a update rule routine(SELECT SINGLE) for each of the required columns and am encountering performance issues. I am checking to see if the ODS extract structure can be enhanced and get all the columns of the other cube in one go.