QDW
When do Back Up jobs get triggered automatically?
1. For all customers: After the NJ completes Major Maint Timing error step successfully
2. Custom step: Some Client Refresh jobs in PRD server have a step to trigger back up job after foundry refresh step completes
True/False: Foundry Refresh job runs daily for all customers
False.
Some might be on a daily schedule, some on weekly. Some customers don't have it on a schedule and DHP kicks it off manually.
What should we put in the ticket description when we see Access to S3 Wip Error with date before 2023?
We don't open a ticket.
Once you find a Measure ticket, what channels do you alert?
1. Customer channel
2. Measure-Implementation-Team channel with consolidated daily summary of tickets
Which state was Sandeep's Production Engineering job in?
Tamil Nadu
True/False: PI db has logs for all customers
False.
PI db has logs for most customers, except GE which is a multi-tenant customer. New customers that are still not live will also need to be requested to be added to PI db after servers are set up.
What team should we assign space issues identified in Foundry Refresh?
DevOps via a QDWHOSTING ticket
What should we put in the ticket description when we can't open/see Error, Alarm Date, Description and other information on the Notification tab?
We put the number of errors we can see in the ticket description.
Which job updates vista?
Bindery Export job
It pushes data from bdr tables in the Reporting (i.e. Foundry) db to Bindery FE and Vista FE.
How long has Chetan been with CT?
Around 10 years. He joined in Dec 2013.
True or False: MAJOR Maint Timing errors are a subset of Maint Timing errors
True
True/False: Foundry refresh always happens in RPL server
False.
There are 2 flavors of FR configs: One allows refreshes in QDW (PRD) server and the other one refreshes in RPL server. Customer environments will be configured to one of these flavors
Should we open another DQA ticket if we already open a ticket for the same source in the past?
No, we only comment the driver ID in the old ticket.
Are Data Management (DMAN), Data Monitoring, Connector Team and Measure Implementation Team all part of the larger 'Data Operations' team?
Yes
1. How many siblings does Varsha have?
2. What did Kushi do her engineering in?
1. Two (one sister and one brother)
2. Biomedical/Medical Engineering
How often does the Cost Management job run for a customer? How do you trigger an ad-hoc run?
Depends on the frequency that is configured using 'MEMDashboardCalcFrequency' config item in Console. Can be configured to NULL (never), weekly, monthly, onnewdata
Ad hoc run: Run the 'CR_RunOverrideUtilEventAlg' job in SSMS so that RunOverrideUtilEventAlg config value updates to 1 in dbo.config. Next NJ will trigger the CMF job.
If a foundry refresh is in failed status, and the next refresh succeedes, should you still open a ticket?
No.
Foundry Refreshes fully each time (no incremental processing), so if it succeeds, previous failures can be ignored
What source Status on the Notification tab should we us for monitoring Spark Errors?
Only complete
Can a connector transform run when a connector is 'gated' in console?
Can a connector export run when a connector is 'gated' in console?
Transform - yes
Export - No
Export is blocked by gating so that data does not make it downstream without validation
1. How old is Swarup's son?
2. Which city did Debanjan start his first job in?
1. Five years old
2. Mumbai. Not Pune lol
What steps of the NJ should we raise error tickets for even if the steps passed in subsequent NJs?
1. Any steps that start with "Staging Load..." Ex: Staging Load with SSIS, Staging Load MPI (since this data gets truncated)
2. Hierarchy Load (since this failure only occurs when we load a new hierarchy, and in the next NJ the step may show as passed because there is no new hierarchy to process). If someone has addressed the hierarchy error, we can stop reporting it after that
What downstream apps does Foundry populate?
Foundry populates Bindery and Vista apps
What wip error tier is "Error During Unpack"
Tier 1
What are the 3 categories of QDW/back up/refresh job errors we are aiming to track? Failures (soft/hard), and what reports?
1. Failures (soft/hard)
2. Jobs not run in 7 days
3. Long running steps
1. What state did Harsh grow up in?
2. What company did Pooja work with right before joining CT?
1. Chhattisgarh
2. Wipro (IBM)