PSA load

[Former Member]

Hi all,

Can you let me know regarding the following issues?

1) Do I have to delete data if I reload data with 'FULL load' option because someone already did 'initial load' and 'delta load'?

2) I enhanced 4 CHARs to my 2LIS extractor, do I have to reload with 'initial load + deltal load' OR ' full load' to catch the values for those new fields?

Thanks

J.

[Former Member · Accepted solution]

Hi John,

Here, you are talking about LO extractor enhancement. So, If the deltas are happening regularly, the Full load is only going to get you the data in the setup tables. You can not re-init by deleting the init pointer as you will loose the data from delta loads. You will need to redo the setup tables then. The best thing would be to check if you can fill these 4 characters with a recursive load somehow (if you are loading into an ODS) and then, the regular delta loads will have the new logic in place. Hope this helps.

Thanks and Regards

Subray Hegde

[Former Member · Accepted solution]

Hi Subray,

This is a testing environment so delta load doesn't help. I am trying to clear my concerns and can u point out for me?

1) do I have to delete data in order to process 'full load' if there were 'initial load' and 'delta load' in PSA?

2) Delta load only catch the values of 'new' IOs after changed, right?

Thanks

J.

[Former Member · Accepted solution]

Hi John,

Since it is your test system, data loss does not matter I guess.

1. You do not have to delete the INIT for doing another FUll load but, you need to mark the Full load as Full Repair load. The full load picks up the data from Setup table so, all the data that came in as delta will not be updated for the new fields. So, the data is not uniform. If you want the data to be uniform, redo the setup tables, drop the load and then, re-init.

2. You are absolutely right. Delta load only loads the changes from the last delta.

Thanks and Regards

Subray Hegde

[Former Member]

Hi,

1) Do I have to delete data if I reload data with 'FULL load' option because someone already did 'initial load' and 'delta load'?

You can mark your full load as full repair request before you start the IP, in the settings; and it wont require you to delete as well.

.2) I enhanced 4 CHARs to my 2LIS extractor, do I have to reload with 'initial load + deltal load' OR ' full load' to catch the values for those new fields?

Full load is required to catch the values for those fields as well.

Cheers,

Habeeb

[Former Member]

Hi,

You can create a one time generic datasource to load the history data for the enhanced fields as the deltas will bring in only data from that point onwards.

Cheers,

Kedar