1. I have a detailed ODS with 4 keyfields. I am planning to build a cube over this ODS without using any of the key fields. The cube I am looking has very few characteristics when compared to the ODS. I was wondering if there would be any impact on the number of records and/or data. Is there any difference w.r.t to key fields and chars in InfoCube in terms of start routine/update routine to the Cube.
2. I have a standard ODS which gets data through a delta capable infosource. Can I use the same infosource to load data into a Cube directly w/o using ODS in between. I was wondering how would the delta be handled in these 2 different cases as ODS has overwrite and Cube has addition. I am looking at FI infosource.
Any help would be greatly appreciated.