Difference b/n choices under Processing in InfoPackage

[Former Member]

Hi Gurus:

In Infopackage, under Processing tab, what is the difference between

1st option (PSA & then in to Data Target) & the

3rd option (Only PSA - update subs in Data targets)

Thanks & Regards...

[Former Member · Accepted solution]

Hi,

Psa n then into data target(package by package):

A process that writes the package to the PSA table is started for <b>each data package</b>. When the data has been successfully updated to the PSA, the same process then writes the data to the data targets. Posting of the data occurs in serial by packet.

Only Psa(Update subsequently into data targets):

Using this method, data is written to the PSA and is not updated any further.

You have the advantage of having data stored safely in BW and having the PSA, which is ideal as a persistent incoming data store for mass data as well. The setting for the maximum number of processes in the source system can also have a positive impact on the number of processes in BW.

To further update the data automatically in the corresponding data target, <b>wait until all the data packages have arrived and have been successfully updated in the PSA,</b> and select Update in DataTarget from the Processing tab page when you schedule the InfoPackage in the Scheduler.

A process that writes the package to the PSA table is started for each data package. If you then trigger further processing and the data is updated to the data targets, a process is started for the request that writes the data packages to the data targets one after the other. Posting of the data occurs in serial by request.

reward if helpful...

shylaja.

[Former Member]

Hi MK,

In case of PSA and Data Targets/InfoObjects in Parallel (By Package): This method is used to update data into the PSA and the data targets with a high level of performance. The BW system receives the data from the source system, writes it to the PSA, and starts the update immediately and in parallel into the corresponding data target.

IN case of PSA and Then into Data Target/InfoObject (by Package): Posting of the data occurs in serial by packet.

Compared with the first processing option, you have better control over the whole data flow with a serial update of data in packages, because the BW system carries it out using only one process for each data package.

[Former Member]

In a way both options put the data in PSA & then will take the data to Data Target from PSA...

Is the 3rd option just used for ODS's where ODS activaton is needed to make the data active ?

I have scenario where 3rd option is being used & the data target is ODS.

Please suggest..Thanks

[Former Member]

Hello,

Please go through this link

http://help.sap.com/saphelp_nw04/helpdata/en/b8/5b723b9b4f8f7de10000000a114084/content.htm

Hope it helps.

Regards,

Praveen

[Former Member]

Hi,

3rd. means: first all datapackects will be completely loaded into psa and after that a batchprocess can store the psa into you datatarget (io's, ods or cube)

/manfred