different source systems

[Former Member]

Hi

Data is coming from 2 source systems 1. flat file 2. R/3

how can i design the cube with data coming from different source systems

Plz help

Regards

[Former Member · Accepted solution]

Hi,

You can design for DSO, it will have over write functionality. After DSO, keep Cube for better reporting.

You need to create two transformations, data sources are different. Seperate for FF.

Based on granularity of data you ahve to choose Key fields in DSO as well in Cube also.

Reg

Pra

[Former Member]

answered

[Former Member]

Hi,

You can do it in many way, As Mr. Tarak said, its one of the good method, but in that you required that for both the data you know the Key. So you can design the DSO.

or else, directly you can go for Cube W/o DSO,

or else, one Data source with DSO and another direct.

Depends on data load mode. is it delta or full? For DSo you required Key field.

Regards,

[Former Member]

Some of the fields are coming from flat file and remaining fields from r/3

in that case i would have to go about.

Mode is Delta

Regards

[Former Member]

Hi,

First u load to DSO separately from the source systems by full load then do the delta to the cube.It will work...

Thanks

[Former Member]

If the source system is other than r/3 or flatfile, then too, is it the same procedure

Regards

[Former Member]

HI,

Yes...If u use DSO between source and cube it should be the best method...

Thanks

[Former Member]

Hi,

Use DSO before the Cube.Do the full loads to DSO from the source systems by creating Two Transformations and Two DTP's.Then Do the delta loads to the Cube by one to one mappings from DSO to Cube.

[Former Member]

Some of the fields are coming from flat file and remaining fields from r/3

in that case i would have to go about.

Mode is Delta

Regards