Skip to Content
0
Former Member
Jun 03, 2009 at 09:04 PM

New status for changed records or Additive Delta

192 Views

Hi Guys,

I have a design question for ODS and Extractor.

The requirement is as follows...

There is a table in CRM with service point as primary key. The fields in the table for example are bill account and Meter ID. Key figure is a XYZ value. In CRM for that Bill account Meter ID combination the XYZ value will change every year. In CRM the same record is being updated with changed value of XYZ. But in BW when the delta is being sent I do not want it to update the existing record but add it as a new record. This way the history can be tracked for previous years XYZ value.

What is required to make this happen?

When creating the extractor I think I should give the delta as new status or additive delta?

What should I indicate as delta specified field?

For the ODS ( I am on BI 7.0) should I create the normal ODS or should I create the write Optimized or something for this requirement ( I dont remember right now the 3 types of ODS we can create).

Your inputs will be greatly appreciated.

Thanks

Kumar.