Description
for ex. for sku F000130986
MAster data not coming in stage from UDH_DEV so S2O SIQ not able to load data in Mango db
AND PIR data reads API from Mongodb not able to populate it.
Checking with UDH team on master data missing for few of skus e.g. F000019823
For below query in UDH DEV its not populating for Country & MArket
SELECT p."country_key", p."region",p."market_key",
CAST(gch."country_desc" AS NVARCHAR(60)) AS "Country" ,
CAST(gch."market_desc" AS NVARCHAR(60)) AS "Market"
FROM "pgsudh_cdm"."apo_country_product_master" p
LEFT JOIN "pgsudh_cdm"."GLOBAL_COUNTRY_HIERARCHY" AS gch ON
gch."country_key" = p."country_key"
AND gch."region_key" = p."region"
AND gch."market_key" = p."market_key"
WHERE p."material_key" = 'F000019823' AND p."snp_selection_filter" = 'STO'