NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
'' Example of retrieving information from a linked table''
</div>
{{Note | It is only the Country Structure of Locations that is flattened, other Country structure references (both system and CDFs) have to be retrieved by SQL views.}}
[[Image:SAG CS flattening1.png|300px|center]]
<div align="center">
</ol>
{{Note| The Post Processing SQL scripts including SQL views needs to be re-applied '''every''' time a staging area database is updated i.e. re-created.<br/>I you would like to test a SQL script without running the Staging Area Generator (of course only works if there is an '''existing''' staging database):# Open a command window# Go to ''C:/IMSMAETLTool''# Run the following in the command window: pgsql\bin\psql -U imsma -d staging -h localhost -L sql.log -f sqlscripts\filename.sql }}
Contact your [[Information Management Team | GICHD IM advisor]] for help in developing SQL statements according to specific requirements.
{{NavBox Business Intelligence}}
[[Category:VIE]]
