Changes

Jump to: navigation, search

Post Processing SQL Scripts

613 bytes added, 14:08, 23 October 2015
no edit summary
</div>
For more on column names in the Staging area, see [[Name Rules Staging Area]].  === How to apply the Post Processing SQL script ===__NOEDITSECTION__ After you have developed and '''tested''' the script with a SQL tool (e.g. PGadminIII or Navicate):<ol start="1"><li> Save the script as a text file with file extension .sql e.g. MySQLscript.sql in the folder ''C:\IMSMAETLTool\sqlscripts''<li> Start the [[Using Staging Area Generator | Staging Area Generator]] <br/>[[Image:PostProcess sqlfile.png|375px|center]]<li> Type in the full name of the SQL script<li> Start the database generation.<li> Your script will automatically be applied in the end of the database generation.</ol>Contact your [[Information Management Team | GICHD IM advisor]] for help in developing SQL statements according to specific requirements.
{{NavBox Business Intelligence}}
[[Category:VIE]]
6,632
edits

Navigation menu