I am currently getting data from 3 Datasources into DSO1 and data from 2 DataSources into DSO2.I just have the following doubts.
1) Datasource 1,2,3 into DSO1 have different KeyFigures in each Datasource some Common Characteristics. So I map acordingly.
Mapped to KF1 of DSO1
Mapped to KF2 of DSO1
Mapped to KF3 of DSO1
In each of the Transformations, I leave the rest of the keyfigures which are not present in that particular Datasource without Any Transformations(Sometimes, it takes as initial Values).
Does tthe Order of Loading data into DSO1 from 2 Diffeent DataSources. Are the Keyfigures going to be overwritten with blank Values.
2) When I load data from the two DSO's into an InfoCube, then the same issue might occur.How does the Order of Loading Data from 2 DSO,s into an infoCube affect the DataModeling
I know, it is quite Confusing.But Please Provide your Valuable inputs.