Data Modeling Issues

34 Views

Hi

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.

For Example.

DataSource 1

KF1

Mapped to KF1 of DSO1

DataSource2

Mapped to KF2 of DSO1

DataSourcce2

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.

Regards,

Samir