This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Engineer at Square. The payment methods table contains null values for certain fields depending on the method type. For example, wallets and bank accounts may not have an expiration date or a last-four-digits identifier. Before loading this data into the analytics warehouse, you need to fill these missing values with sensible defaults so downstream reports do not break on null values.
You are a Data Engineer at Square. The payment methods table contains null values for certain fields depending on the method type. For example, wallets and bank accounts may not have an expiration date or a last-four-digits identifier. Before loading this data into the analytics warehouse, you need to fill these missing values with sensible defaults so downstream reports do not break on null values.