'init load' & 'full load'??

[Former Member]

Hi all,

Can anyone correct this if i am wrong?

--My question is that I need to delete 'init load' & re-load it with 'full load' and then create the 'process chain' to transfer data periodically after I loaded data first time with 'init load' and the data was tested, right?

--If not, what it is after I loaded data successfully with 'init load' in the first time?

--Do I always need to use 'init load' for first time data load? If not, what is the situation that I need to use 'full load' for the first time data load?

Thank you

[Former Member]

Hi john..

I think you guys are confused with init/delta load and full loads. Lte me try to clear the concept.

There are two kinds of loads.

1. Delta.

In case of delta, first load should be a init, which tells the source system to keep the track of changes/new records in order to send only these changed/ new records into BW which flows as delta.

2. Full

In this case ererytime all the records will flow into BW system so init is not required.

So in your case, the answer is :once you have loaded the full data, now u want to get back to delta, you have an option called init without data transfer in which no data is transfered into BW as all the records have come in full update but still u can go ahead with delta. So after your full load run init without data transfer and your system will be ready for delta.

for the second case : Init loads is only once takes place. So first time you run init and then you put your delta infopackage into process chain and it will run successfully.

Third : once you have done an init, there is no need for full. Delta infopackage has to be designed and should be used in further process chains.

Hoep i have cleared some points. If u feel ur further confused, post it. Once again ill try to clear

Sriram

[Former Member]

Hi Sriram,

Thank you for contributing your experience. According to your information, no matter what method (full load/ init load) I used for the fist time dataload, I can use that infopackage (I created for the first time dataload )to run the process chain without creating another infopackage. If I am wrong, please correct me. If not, please explain it. Thanks

[Former Member]

Hi John,

If the first time load was an Init, then your InfoPackage would have this option selected. If you include this in a process chain then it will not work, because you would not want to do another init (anyway you will not be able to do another init without deleting the previous one).

If the first time load was a full load and you include this InfoPackage in the process chain, then each load would be a full load. You need to see what the objective is.

If however you have done an Init, you can change the <i>same</i> InfoPackage to choose the delta option and include it in a process chain.

Hope this helps...

[Former Member]

Hi Bhanu,

Thank you for the information. I'm worndering if you can help me to solve this issue.

--I used 'full load' infopackage to run the process chain but I got an error message: processing chain error occurred- transactional data load. <b>The line color (the link) between "start" and "load data" is black in the planning view.</b> Do you know what is the problem?

--The above process chain didn't work so I tried to create the 'init load' and and run the process chain with 'delta load' but it didn't allow me to run the 'init load' infopackage. Do I need to delete the 'full load' infopackage with uning the process chain unsuccessful before I run the 'init load' infopackage? Do you know why?

Thank you for help

[salnuaimi]

Nicely described. thanks