7,649
edits
Changes
Jump to navigation
Jump to search
→Processing Steps
Move the files to //mother/bulk/vcdb20q3 and run the load script:
E:\projects\vcdb20q3\Load.sql
===Create the keys===
Standardize company names using Hall normalization without a fuzzy algorithm (see [[The Matcher]]) and matching them to themselves for PortCos, M&As, IPOs. Then create keys for each table as follows:
*PortCo: Coname, statecode, datefirstinv
*M&A (private targets): targetname, statecode, announceddate
*IPOs: issuer, statecode, issuedate
