EDW LAYER

[Former Member]

BI FOLKS,

how to maintain delta in EDW layer (Transaction datastore).

Can one help me on this

Regards

Mahe

[Former Member]

EDW situation is where you ned to get data from mutile sources, consolidate and transform the data. The data that is so consolidated will be transferred( loaded) to various data targets and form there reporting will happen.

While trasferring data from EDW to the reporting layer, you maintian delta.

Ravi Thothadri

[former_member184494]

A transaction datastore is just the active table - the delta would have to be maintained by the extractor or feed the data in the transactional datastore to a normal DSO and you can have a delta there...

Arun

[Former Member]

Thanks for you quick response,

I have requirement like get the data for subsystem to EDW layer then feed it to targets, as usual init and delta but since Transactional data store have one table how to maintain delta in transaction Datastore.

Regrds

Mahesh

[Former Member]

can any help me on this.?

Regards

Mahesh

[Former Member]

Hi,

you use the term datastore, thus I assume that you work with BI V.7, do you?

(the 'Transactional ODS-Object' in V. 3.5 was renamed in V.7. to 'Datastore for direct update').

Anyhow, the question is why do you use a 'Datastore for direct update' ? In 3.5 customers used it sometimes for performance reason instead of a 'normal' ODS-Object.

In V.7 you can use the new 'Write-Optimized DataStore', which also consist only of a single (a-) table and supports fully delta to the targets (with DTPs Data Transfer Processes)

<a href="http://help.sap.com/saphelp_nw70/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm">Write Optimized Data Store</a>

May be this helps a little bit

Regards

Juergen