on 2005 Sep 13 6:52 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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..
Hi Mark!
I think you have to map it to ROCANCEL field...
Bye,
ROberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
64 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.