Enterprise Data Warehouse Architecture (EDW)

We have already seen the Architecture of Standard DSO, Infocube..
Architecture of Write Optimized DSO is different from standard..

we have 3 tables in standard DSO... New data, Active Data, and change Log..

But in Write Optimized DSO we have only 1 table, Active data table.. So we don't have to activate the data inside DSO.. It is used only for staging purpose.... and It wont have delta Capability as it don't have change log table..

Lets create a flat file and load to infocube following EDW Architecure..

Activate Datasource

Now we have our data in PSA of datasource..

Our next job is to create a write optimized DSO..

now add the key fields and data fields..

our DSO is ready now..

now create transformation and DTP to pull data from Datasource.

activate trasformation and create DTP

Now we have data in our Write optimized DSO...

Different from Standard DSO... Write optimized DSO have only 1 table.. active table...

click on Active data

So we have data in stage 1 DSO...

now lets create Stage 2 DSO and move data into that..

now add the key fields and data fields...

Activate DSO

Now create Transformation and DTP to load data from write optimized to Standard DSO..

Activate Transformation and create DTP

now data is available in the new data table of standard DSO.... Activate data to move data to Active Table..

click on Start...

Now data is available in Active table of Standard DSO...

Now lets Create a cube and move data to Infocube..

Add all dimensions and keyfigures...

And activate Cube


Now create Transformation and DTP to load data from DSO to Cube..

Activate Transformation and create DTP..

Keep extraction mode as Delta.. and execute DTP..

Now our data is available in Cube... lets display that data..

Now lets make some changes to the source file and see how duplicate records are handled.

A new transaction is added to the source file...

This is how our data flow looks like..

Now lets run the infopackage to pull data..

Now run DTP to pull data to write optimized DSO..

Now run DTP to pull data from Stage1 DSO to Stage 2 DSO..

now lets see data in our stage 2 DSO( standard DSO)

Our data is available in New data table....

Only 1 record is allowed to pass through our Write Optimized DSO.

Now lets activate our data in Stage 2 DSO..

Now lets see data in active table and change log..

This is how duplicate records are handled by Stage1 DSO..

Best SAP training in Kerala

Best SAP training in Kochi

Best SAP training in Ernakulam

SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana