NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
|-
| align="left" | '''3 - Post Processing SQL Scripts (optional)'''
| align="left" | In this optional field it is possible to provide the full path and name to of a '''validated SQL file'''. Whatever is specified inside that file will be executed on the staging area database after its generation. This can be valuable in several use cases, for example:* If a staging area with only a subset of the IMSMA data should be generated (in this case the SQL file would include DELETE statements)* If sensitive data (e.g. victim names and addresses) should not be transferred to the staging area (in this case the SQL file would include UPDATE statements to set all the victim names and addresses to NULL)* If data has to be pre-computed processed for reporting purposes
* If additional database views are necessary, also for reporting and analysis purposes
Contact your GICHD IM advisor for help in developing SQL statements according to specific requirements.