I have an ODS feeding an InfoCube. Deltas are running fine. Now I have a new req to add 1 new field to ODS and 2 new fields to InfoCube.
This new field in ODS is a data field. I extended my ODS and did a full self-load onto itself (ODS) to populate this new field.
Coming to InfoCube, I extended the cube with 2 new fields and created 2 dimensions, 1 for each of new fields.
I heard someone saying I need not drop the cube and re-load it to populate the new fields.
How is this possible? I thought if I run the delta load from ODS it would create duplicate records in InfoCube.