We have connected to an external data source that is the source of key Foundation Data components listed below:
Company Postal Codes Site Region Company Site Assoc People I have created AIE jobs to load these into custom created staging forms, where I perform initial data checks, transform if necessary and then load into the data load forms such as COM:LoadCompany etc. In order to promote them from Unvalidated DL_Status to Validated and then Promoted, I was thinking of creating two escalations. 1) The 1st escalation would modify all these records with a DL_Status of Unvalidated to set z1D Action to VALIDATE so that the validation filters fire. 2) The 2nd escalation would then modify records that has a null Error_Flag and a DL_Status of Validated to set z1D Action to LOAD I'm torn between using Escalations to do these two steps and AIE thinking that AIE may perhaps work more efficiently than Escalations. If anyone has attempted an auto validation and load with minimal manual intervention for data without errors, what did you'll use? Cheers Joe _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
