repo - Hari-dta/hari GitHub Wiki

<dq_checks>
    <query>
        <id>DQ_1</id>
        <sql>select rdv_eom.interest_status_account_eom.s5pf_ststcs_clctd from  rdv_eom.interest_status_account_eom where interest_status_account_eom.s5pf_ststcs_clctd is NULL or interest_status_account_eom.s5pf_ststcs_clctd = ''</sql>
    </query>
    <query>
        <id>DQ_2</id>
        <sql>select * from RDV_EOM.CUSTOMERS_EOM where GFPF_CSTMR_ID is NULL or GFPF_CSTMR_ID = ''</sql>
    </query>
    <query>
        <id>DQ_3</id>
        <sql>select {$column} from {$schema}.{$table} where {$column} is NULL or {$column}</sql>
    </query>
    <query>
        <id>DQ_4</id>
        <sql>select {$column} from {$schema}.{$table} where {$column} is NULL or {$column}</sql>
    </query>
    <query>
        <id>DQ_5</id>
        <sql>select * from RAW_DATA_VAULT.ADDITIONAL_CSTMR_INFO_FIELDS where  CIS024PF_CUSTOMER_ID is NULL or CIS024PF_CUSTOMER_ID = ''</sql>
    </query> 
    <query>
        <id>DQ_6</id>
        <sql>select * from raw_data_vault.individual_customer  where  cisi02pf_frst_nme_ar  is  NULL or cisi02pf_frst_nme_ar = '' </sql>
    </query>
    <query>
        <id>DQ_7</id>
        <sql>select * from raw_data_vault.accounts_sc  where scpf_nominated_acc_indicator is NULL </sql>
    </query>
    <query>
        <id>DQ_8</id>
        <sql>select * from pre_process_udm.account_active  where source_system_account_id is  NULL </sql>
    </query>
    <query>
        <id>DQ_9</id>
        <sql>select * from ifrs9.limit_control_details_dly_new where hhpf_grp_nme is  NULL or hhpf_grp_nme = '' </sql>
    </query>
    <query>
        <id>DQ_10</id>
        <sql>select {$column} from {$schema}.{$table} where {$column} is NULL or {$column}</sql>
    </query>
</dq_checks>