Skip to Content
0

How to create generic extractor based on multiple custom tables with delta functionality

Mar 15, 2017 at 09:02 AM

146

avatar image
Former Member

Hello All,

Need Solution for an issue as described below:

We have a requirement of creating generic DS using 2 generic table (Hdr & Itm).

-Hdr table has key field (say Invoice GUID) and Itm table has key field (say Invoice Item GUID and Invoice GUID as normal field).

-View has Invoice Item GUID field as key field

-We created a view on these two tables using condition Invoice GUID from both tables.

-Both tables has created on & changed on fields.

-Inside view we added the above fields from both tables.

-Using this view we created a Function Module.

-logic to capture delta is: when new record enters then created on filed gets value and changed on field will be blank (created on to be considered)and when old records gets updated then the changed on field will be updated and created on will have the value(changed on to be considered).

-On which one field we can define delta.

-In BW, we need to create a DSO to load data at regular interval and then to the cube

-How to delta load will work for the DSO

How can we achieve this and the process we follow is correct or not? Please help in solving this issue.

Thanks & Best Regards, Ashish

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Mar 16, 2017 at 07:45 AM
0

Create one dummy date field and set as dummy date field as delta(Function Module)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Chandra,

Dummy field to be added in the view and data will be updated for this field from FM.

Can you share some sample code to do the same for the above requirement of capturing delta.

Thanks.

0
Koen Hesters Mar 16, 2017 at 07:51 AM
0

Correct and fill the dummy date field with the (max change or create date)

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Koen,

Can you share some sample code for the same.

Thanks.

0

Hi,

I'm not quiet sure about what you got right now in your code, but you can loop over your "view" and compare the dates, the "max" date will be entered in your dummy date (datsapbw)

Grtz

Koen

0