From: "Sankar, Kousalya (HA Group)" <KSankar@HollandAmericaGroup.com>
Subject: Re: Promos loaded different from QA to Stage
Date: June 21, 2018 at 2:21:27 PM PDT
Anila,
To sync up QA and Stage with same data for feed and API, We are thinking of these steps
- Stop ETL job on both QA and Stage
- Take weekly snapshot of Voyage and Offer Mongo collections from Prod and upload to Stage and QA Mongo.
- CJ to check UAT voyages on Mongo and update Rate Codes in Polar region if needed
- Point Node API for feed to use Prod Oracle
- Generate feed from QA and Stage (daily or weekly)
- Feed ingestion scheduled to run on both QA and Stage (daily or weekly)
Thanks,
Kousalya
From: "Poreddy, Rohith (HAL Contractor)" <RPoreddy@hollandamerica.com>
Subject: RE: Promos loaded different from QA to Stage
Date: June 21, 2018 at 11:04:55 AM PDT
Please find the details below
QA:
Data file folder location used by ETL job: /cdsshore/test-dwh-data
Node API Mongo location for feed: haluxqamdb02.hq.halw.com
Node API Mongo location for API: haluxqamdb02.hq.halw.com
Are we running feed ingestion on AEM-QA on daily basis? Ingestion I am not sure, but we do upload files every day to S3.
ETL Job Status: Runs every day around 6:30am
STAGE:
Data file folder location used by ETL job: /cdsshore/test-dwh-data
Node API Mongo location for feed: haluxstgmdb07.hq.halw.com
Node API Mongo location for API: haluxstgmdb07.hq.halw.com
Are we running feed ingestion on AEM-STAGE on daily basis? Ingestion I am not sure, but we do upload files every day to S3.
ETL Job Status: Currently the ETL job is disabled on Stage
Thanks,
Rohith