Data load from ODS to Infocube

Question: Hi
I have a ODS with many records with the 0RECORDMODE values ''BLANK" "X" and "N".

The Infocube is empty now and if i upload data from the ODS to Infocube i m able to pull only the records with the 0RECORDMODE = "N".
How can i pull all the records to my cube so that i dont loose history.

Thanks.

Answer:
Hi,

In update routine (start routine script) it is possible to change these recordmode field (X -> N). Indeed if you're interested by 'historical' management, additional fields will probably be necessary (let's say, with value HIST or ACTU or WAIT, etc...) or even fields which store reason of change (let's say 'PURCH ORG changed' or 'Price changed' or 'SO deleted', etc..)

Cheers

Chris

Answer:
Hi tpollur,

If you are loading for the First time ie (init or Full) only "N" records will be updated Bcoz data is sent from Active data.

For only deltas Change log is used.

so you can't get other images.

KEERTHi
Copyright ?2007 - 2008 www.jt77.com