cancel
Showing results for 
Search instead for 
Did you mean: 

generic delta extraction

Former Member
0 Kudos

Hi all,

I made a generic extractor based on view with 8 tables, which 2 tables custom and 6 standard.

I have setting Timestamp and ZDATE field from custom table as point of delta determination, with upper limit 1800 seconds and lower limit empty

The ODS is empty, then I loaded the init infopackage without transfer data and then there is the record into RSA7 delta queue but the LUW is 0.

How can I do, please?

Thanks in advance

Gianmarco

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

For generic delta, once you load the delta and if it fetches any records then the LUW shows 1 in RSA7 else 0. Thats how it works in generic delta extractors.

Try pulling in the delta and see if any records come through. If any records come through then the RSA7 entry will show 1. The next time you pull a delta it'll again show 1 and if there's no records it'll go back to showing 0.

Cheers,

Kedar

Former Member
0 Kudos

Hi Gianmarco,

The o/p is 0 because you did not load any data.

All you have done is Initialize Delta without data transfer.

You need to maitain the data source setting in the Delta table and give dates

for which you want to run the data, run delta and then see the o/p.

I think you got the point why the LUW is 0.

Award points if helpful.

Thanks,

Anu

Former Member
0 Kudos

Thank you,

How can I maintain the data source setting in the Delta table?

Gianmarco

Former Member
0 Kudos

Hi,

To maintain the datasource in RSA7 ie Delta queue, u have to initialize it. the procedure is

1.goto infopackage for the datasource goto Update tab, select Initialze delta process radio button and check Initialization Without datatransfer check box.

After that start the infopackage. now u will get the datasource maintenance in RSA7. check it there.

After this u can get LUW's into RSA7.

Assign points if helpful.

Former Member
0 Kudos

Hi,

This is a custome table,

We have ZBW_delta table in Sm31(t-code)

There you need to give new data source setting,

and the dates for which you want to extract.

This you need to do in the source system.

Thanks,

Anu

Former Member
0 Kudos

I don't have ZBW_delta table, I'm not understand where I must setting my extract structure

Thanks

Former Member
0 Kudos

Do this at BI Side

To maintain the datasource in RSA7 ie Delta queue, u have to initialize it. the procedure is

1.goto infopackage for the datasource goto Update tab, select Initialze delta process radio button and check Initialization Without datatransfer check box.

After that start the infopackage. now u will get the datasource maintenance in RSA7. check it there.

Do this at Source System Side

RS02 --> Data Source u have created and enable the delta functionallity there

Former Member
0 Kudos

As I wrote in the first message I have already loaded the init infopackage without transfer data but after this action there aren't data in the RSA7 delta queue

Can you help me, please?

Former Member
0 Kudos

See your delta is picked by generic data source with respect to the condition that you have mentioned for delta enablement while creating the data source and hence whenever that condition is triggered you will see the data in the RSA7

Many Thanks

Amit

Former Member
0 Kudos

Hi,

In addition to the post that I wrote above, for you to pull the delta you need to make sure for every change the timestamp field that you are using as delta gets populated.

Cheers,

Kedar

Former Member
0 Kudos

How can I check if the field that I choose it's OK for delta determination?

Thank you