Skip to Content
0
Aug 03, 2012 at 04:08 PM

PCM - How to delete all records in the Revenue table?

18 Views

Hi Experts,

Let me start by saying the I'm fairly new to PCM 7.5.

Could someone please help me with this issue? I have been loading the revenue table using flat files using the options available to overwrite and/or summarize. However, if during the second load fewer records are uploaded, the extra records remain in the Revenue table.

For example:

1st Load:

Account Amount

1000000 10

1000001 20

1000002 30

2nd Load: (using replace option)

Account Amount

1000000 10

1000001 20

Revenue table:

Account Amount

1000000 10

1000001 20

1000002 30

If there any way to delete the revenue table to prevent this from happening? Is my only option to load the unwanted records with Amount = 0? I know this would be easier using BPC, but it's not going to be implemented for now.

Thanks in advance.

Al