CptCrusty1 (4/23/2013)
Hey Phil!Flow is as follows:
Text File --> Raw Table --> Staging Table --> Production Staging Table (Different VM) --> Production Table.
A lot, if not all of the Transformations happen in the Staging Table. As a general rule, I don't think any CRUD/MACD should happen once the data is pushed to the production environment.
I'm sure that you have your reasons, but that looks like one-too-many staging tables to me.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.