...
[11:42:55 CST(-0600)] <js70> nope
[11:43:12 CST(-0600)] <TonyUnicon> the advantage if the giant intersect query
[11:43:25 CST(-0600)] <TonyUnicon> is we could identify all the bad rows in the file I guess
[11:43:27 CST(-0600)] <dmccallum54> my assumption is that once we had the validated file we simply batch inserts to the stage tables. if there is a duplicated key in a batch, it invalidates the batch
[11:43:29 CST(-0600)] <TonyUnicon> as opposed to just the first