Delta repeatation/delta update

[#1]

  Hi all,

I small question about delta records.

talking about tx RSA7

In RSA7 we have to tabs

1. Delta update

2. Delta repeatation

in what scenario they both has effective usage in data warhousing

So can give more idea and depth detail about above.

thanks & regards    

[Former Member]

Dear Raman/Martin/Anshu/Arpit,

I agree with all lines.

1. Suppose if the delta repeat in RSA7 has years of data though delta loads are running on daily successful basis. At this situation?

2. Can I make repeat delta repeat table or content in RSA7 empty with ensuring all success full deltas in bw.

3. After successful delta load if i wantedly marked status as to repeat delta then missed data of previous year would be loaded to bw system.

Thank You so much again for more descriptive explanation.

[RamanKorrapati]

Hi Taniya,

1. Delta repeat holds only latest req. there is no chance to hold years at RSA7. Delta means updated data on daily basis.

2. At RSA7 - there is nothing to set. its just for display

3. No. If you set green/success request to red. there is no chance to get last req records. because once req was green, system may sends green/success message so there is no chance have repeat option in this case. think so.

Repeat Delta: For example:

My loads are happening daily at 7AM. so today one delta load was failed. so today request was red. So again i will make my req to red a tpsa level.

i will run my info pack manually, its as last delta red was failed want to do repeat delta, i say yes. its brings yesterday data(Yestreday 7am to today 7 am) and today data(as of now, Today 7 am to 7PM(now my time is 7pm), which are reached to RSA7).

That's the use repeat delta. other that there is no situations to consider about repeat delta.

Thanks

[MGrob]

1. Suppose if the delta repeat in RSA7 has years of data though delta loads are running on daily successful basis. At this situation?

Repeat delta only contains the last broken entry there is no such thing as a big queue..

2. Can I make repeat delta repeat table or content in RSA7 empty with ensuring all success full deltas in bw.

You should not delete anything in rsa7. it only leads to inconstencies. If you delete the init in bw it will also clean the queue.

3. After successful delta load if i wantedly marked status as to repeat delta then missed data of previous year would be loaded to bw system.

once a successfull delta pickup happened you don't need to do anything. actually you never need to do anything in rsa7. you can do all from bw side. the repeat of a unsucessful delta load you trigger in bw and rsa7 will manage itself

martin

[anshu_lilhori]

Hi Taniya,

1. Suppose if the delta repeat in RSA7 has years of data though delta loads are running on daily successful basis. At this situation?
Delta queue will only hold data of the last request and it will maintain until the next successful request loads into BI.I have already explained the same in my last reply.So in any case if your delta loads are running daily then it wont have years of data.

2. Can I make repeat delta repeat table or content in RSA7 empty with ensuring all success full deltas in bw.
Everything you need to do in BI nothing in RSA7. Only in case your delta load fail then you can request for repeat delta by triggering the infopackage again.

3. After successful delta load if i wantedly marked status as to repeat delta then missed data of previous year would be loaded to bw system.
Nothing will happen if you change the setting to repeat delta in RSA7 that is only for displaying the data in queue.

I hope all your queries have been answered in case you need more info.i would suggest to try it practically on your DEV system provided you have access to it.

Regards,
AL

[Former Member]

Hi Raman,

sorry to respond late.

Thanks

For 3 answer

As you knew about my last thread where i asked about the system which was stopped long back. So in that situation if the last delta of year 2012 is failed and running repeat delta in 2013 could successfully bring all records.

Thanks again for briefing more.

Regards

[Former Member]

Hi Martin,

sorry to respond late.

Thanks for nice response

For 1 answer

Can you please elaborate

Thanks again

Regards

[Former Member]

Hi Anshu,

sorry to respond late.

Thanks

yes i have gone with your previous reply, but i wanted to know more so i asked.

this time it is more clear from you.

Thanks again for briefing more.

Regards

[RamanKorrapati]

Hi Taniya,

in production never be that much gap as one year.

as my guess there is no updated data at BW side by seeing your job log.

so check the info cube level, when the last request was loaded?

Still your not clear. Repeat delta works only when last delta was failied.

Delta loads always happens below 24hrs only for FI Data sources.

" So in that situation if the last delta of year 2012 is failed and running repeat delta in 2013 could successfully bring all records"

In reality never be happen like this. production is system was in live and loads happens on daily basis.

check with your team lead or project manger about that data flow.

Thanks

[MGrob]

Hi

You won't have a case where RSA7 holds years of delta when your delta is running fine all documents get picked up from RSA7. Should your delta not get successfully loaded into BW it will be queued as repair delta request. There can't be any further successfull deltas be queued until you pick up the repair delta requests. Therefore you don't have years of data.

hope it clarifies

Martin

[former_member182470]

Hi taniya,

I think you are getting too much confused with the concept.

Repeat delta will be available for the last successful/unsuccessful delta to BW. You cannot have all last year's data as repeat delta. You have to load all historical data through repair full loads/full loads. After that initialize your delta and start running delta loads.

Please do not depend on RSA7 for the last year's data. Hope you will close this thread and open new one.

Regards,

suman

[Former Member]

Hi Raman,

Yes the situation here is like this only.

i dont have any one superior to me.

i followed your points

Thanks

[former_member182470]

Check my previous reply..