cancel
Showing results for 
Search instead for 
Did you mean: 

Extract DELTA LOAD in SQL View

Loed
Active Contributor
0 Kudos

Hi guyz,

I'm just curious if it is possible to have a DELTA LOAD if I'm using an SQL view as my source going to BW?

If yes, how will I do it?

Thank you!

Loed

Accepted Solutions (0)

Answers (4)

Answers (4)

Loed
Active Contributor
0 Kudos

Hi guyz,

Just want to ask if using the FIL0 will extract a DELTA from SQL server?

Using Generic BW Deltas - Modeling - SAP Library

I tried to implement the link given by Jino but no additional options were shown after choosing FIL0..I wanted to have a DELTA LOAD in our masterdata since every month the records are increasing roughly 100,000 records..I'm doing a DAILY FULL LOAD since 2013 but right now the records are already 3 million+ which takes almost 10hours for masterdata loading just for this object..

Here is the status of our BW server:

Any help?

Can you post here the link of the document? I can't find exact match in the forum/google using your keywords..

Since we are using BW 7.0 so the other options don't appear? Is that right?

May I know what codes did you use for this DELTA functionality in SQL?

Regards,

Loed

KodandaPani_KV
Active Contributor
0 Kudos

Hi,

we extracted the data form MY-SQL and MS-SQL  to SAP BI.

but i written the info package and DTP routines while extracting data from source to target.

Thanks,

Phani.

Loed
Active Contributor
0 Kudos

Hi Kodanda,

What routines did you make? Can you show me an example?

Thank you!

Loed

jino_jose
Active Participant
0 Kudos

Hi Leod,

If you are on BI7.3 you could created the delta at datasource level. Please see below link

Thanks,

Jino

Loed
Active Contributor
0 Kudos

Hi Jino,

I checked the thread you have posted..Just a query, is this also possible in BW 7.0? Since I can also see the FIL0 Delta with After Images option?

Thank you!

Loed

former_member183012
Active Contributor
0 Kudos

Hi Loed,

I have not did this one but there is one document which will tell you how to implement this case in SAP BI.

Please search with "delta load from sql database in sap bi"

Hope it will be informative.

Regards,

Ganesh Bothe

Loed
Active Contributor
0 Kudos

Hi Ganesh,

Can you post here the link of the document? I can't find it in the forum using your keywords..

Thank you!

Loed