cancel
Showing results for 
Search instead for 
Did you mean: 

0RECORDMODE Question

Former Member
0 Kudos
2,388

Hi Everyone,

There are some conflicting replies and opinions concerning 0RECORDMODE.

We are using 2LIS_13_VDITM and loading to an ODS and then subsequently updating to an InfoCube.

I can see 0RECORDMODE in the transfer rules, but this is not mapped to anything. We loaded data to the ODS and 0RECORDMODE is NULL/blank for all records.

Question(s):

1. What does 0RECORDMODE get mapped to? I have read note 399739 and its values, but what to assign it to?

2. If someone could give a scenerio on question 1 and the different options and final result it would be great.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Mark,

Do not assign any fields to the 0RECORDMODE in the transfer rules. You would see the significance of the 0RECORDMODE if you look at the change log table of the ODS. When the data is loaded for the first time the 0RECORDMODE would get assigned a value "N". Now if you reload the data after sometime and lets saya 1 of the records were modified then there will be 2 additional records in the change log table with 0RECORDMODE "X" and "" where X corresponds to Before image and "" corresponds to After image.

So when you do a delta from the ODS the system automtically picks up the changed records from the ODS (using the change log table) based on the 0RECORDMODE value.

Hope I have made things clear.

Bye

Dinesh

Former Member
0 Kudos

Thanks Dinesh. Answered my problem exactly

Former Member
0 Kudos

Dinesh ..

Really you are Great..

Very Good Explanination...............Excellent

Thanks

Saloni

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

look at this thread

it will help.

Also, the 0RECORDMODE is a mechanism that supports the delta loads and logic.

So you don't have to map it to any field.

Edan

Former Member
0 Kudos

Hi Edan,

This link takes me to the General BI forum and not any particular topic.

Can you recheck this...Also, you are saying to leave 0RECORDMODE unmapped in the transfer rules? DO NOT map it to STORNO(ROCANCEL)?

I understand the logic of 0RECORDMODE and the different values and controlling the delta (from a high level overview). Just wanted some elaboration.

Thanks, Mark.

Former Member
0 Kudos

Hi Mark,

This post has it elaborated..Look at dineshs reply..

Ashish.

Former Member
0 Kudos

Hi Ashish,

Thanks for the link. I can see all of this, but do I have to map 0recordmode to anything in the transfer rules. Viewing the ODS ACtive table 0recordmode is in every record, but blank (so after image). I think this is OK, but this is the confusion I was speaking about. Some people say to map it while others do not. Which one is it? Can you also confirm that the datasource determines the type of delta. So 2lis_13_vditm determines the delta type and in this case it's a blank, after image.

I really appreciate this. If this can be answered I will close this topic and rate highest points. I believe I am correct on the above, but just want to verify for 100% sure.

Thanks.

Former Member
0 Kudos

Hi Mark,

As far as my experience goes, I think as the Extractor is taking care of the delta mechanism, the 0recordmode left blank will mean the ods is updated in overwrite mode..

We are using datasources which are delta enabled and in all such cases 0recordmode is left blank..not mapped to anything..

Ashish..

Former Member
0 Kudos

Hi Mark!

I think you have to map it to ROCANCEL field...

Bye,

ROberto