Probably Microsoft Access is more than adequate for handling the demographic profile
information. However, I wanted to practice manipulating the the demographic profile i
<<dp_profiles_oracle.zip>> nformation in Oracle to prepare myself for the
Summary File 3 release. The attached zip file contains files for creating and loading the
demographic profile tables into Oracle.
I loaded CT first, and then loaded NY and NJ. It would be easy for me to modify the files
and load the national summary tables as well. Because of my process, the control files
are different for NY and NJ because I was appending the data to an existing populated
table. Oracle users will most likely need to edit the files to change the paths and file
names. I added ".txt" to the batch files so that anti-virus software does strip
the attachments and I do not get hate mail from system administrators. I also changed my
userid information for obvious reasons.
Daryl
--
Daryl Scott
South Western Regional Planning Agency
Stamford Government Center
888 Washington Blvd., 3rd Floor
Stamford, CT 06901
Tel: (203) 316-5190
Fax: (203) 316-4995
E-mail: dscott(a)swrpa.org
Show replies by date