ETL troubleshooting recipes

Issue: ¿epatienting (rename externalID well after work on sample has started)

System: GAP

Remedy: Refresh Sample_Attributes datamart. In GAP_PROD.ANALYTICS schema issue SQL statement like this:

INSERT INTO sample_attr_special_refreshes

SELECT 'SM-' || a.sample_id, SYSDATE 

FROM sample_attributes a

WHERE a.collaborator_sample_id IN ('old_externalID_1','old_externalID_2')

Issue: When upstream data change, some samples in PDO_STAR5 might need to be refreshed.

System: GAP

Remedy: Request a refresh for PdoStar5Agent by issuing SQL like this in SEQPROD.COGNOS:

INSERT INTO pdo_star_special_refreshes VALUES('PDO-1', 'SM-12345', sysdate)