Hi All,
In EDW architecture, we have 3 different layers
1) Staging
2) Transformation
3) Datamart Layer
Each layer has its own purpose and i would like to concentrate on a scenario.
Say Sales order header, item and schedule line are pulled from R/3 to BI.
Staged in STAGING LAYER in Data store.
Transformed in the Transformation layer in Data store/ Cube.
Created cube in the Datamart layer, created Multicubes/Infoset and Bex Reports.
This is possible because the extractors are ODS Compatible. But not all extractors are ODS Compatible.
Question
If the Extractor is not ODS compatible, how do i design something that would be in sync with the EDW Architecture ( PSA -> ODS/DATASTORE -> CUBE) ?
Reply will be greatly appreciated.
Thanks
Niveda