generic delta extraction

[Former Member]

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

[Former Member]

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]

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]

Thank you,

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

Gianmarco

[Former Member]

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]

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]

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

Thanks

[Former Member]

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]

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]

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]

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]

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

Thank you