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
