DA_Australia readme upload / update of amt
Prerequisites:
Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
Working directory dev_aus.
- Run create_source_tables.sql and additional_ddl.sql
- Download and extract files from \kha-file01\Odysseus\DA_AUstralia
- Run in devv5: SELECT sources.load_input_tables('Da_AUstralia'); (some data in drug_mapping_3 and fo_product_3 are bad - need to delete extra columns, 3 and 1 respectively in some rows)
- Run load_stage.sql
- Run generic_update: devv5.GenericUpdate();