cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Management: How to...

Former Member
0 Kudos
64

Hello Experts!

Please enlighten me on how to do:

1.) Init.. What is it for? How do I do this?

2.) Delta... What is this for? How do I do this kind of load?

Thank you!

Philips

Accepted Solutions (1)

Accepted Solutions (1)

edwin_harpino
Active Contributor
0 Kudos

Answers (2)

Answers (2)

Former Member
0 Kudos

Before discussing Init and Delta, you need to know what full is: when you do full load, all data from the source is getting loaded, which will bring everything. This load is not efficient and resource consuming and even in some cases you may not do it because too much data getting involved. So, that is why there is Init and Delta comes into picture. When you do Init load, you are setting a delta pointer, means it is just a marker saying that everything from this point on has been taken care of, then after you do init load, going forward, you do delta which will bring (New or changed records). Unlike the full load, after you do init and next delta will bring fewer records which makes it mare efficient and less resources.

Hope it is clearer.

thanks.

Wond

former_member195940
Active Contributor
0 Kudos

Philips,

Init load is used to pull the records from the source system to BW system.The main purpose of INIT load is to trigger "delta" loads from the next load. you have to create an info package and selct "initialization" with data transfer to do this.

delta loads are used to get any changed records or updated records from the source sys to BW sys. after doing an INIT you can do an delta load. you can do this in the same way as mentioned above, except for you need to select delta under "update" tab.

also, search in forums, you will find tons of informations on the same topic

assign points if helpful

Kalyan