According to your's mail, it was about the CDA query.
I tried to check the CDA query, and I found the CDA query not correct. You can edit the CDA quety and see detail below ka.
- The SBR_NUM column in DIM.SBR_DIM table mean slider Seq#. It not the BO# in ET ka.
So you can change the SBR_NUM column is the WO column in HGA.HE_FACT table ka.
- You can use "NP" not use "PES&TH" in the WO column e.g. NPG8005, NPG8007, and add SUBSTR code before the WO colunm because data in the WO column have 8 digit but you need 7 digit ka.
- Add date for fix the data.