1 Reply Latest reply: Mar 16, 2016 10:37 AM by Florent Lelarge-Otiniano RSS

    chargement très long

    Maurice ludo

      Bonjour,

      j'ai une application en place, je voudrais mettre les condition suivant:

      récupérer tous les DEPARTMENT_N_ 2 = IS EMT sans company_ID = NL90

      et récupérer tous le company ID NL90 meme qd DEPARTMENT_N_ 2 = IS EMT,

      j'ai mis en place ce script qui tourne bien tous seul mais de que je l'insère dans l'ensemble de application dont j'ai besoin, il tourne sans arrêt:

      voici le script

      _COSTCENTER:
      LOAD
      DWCC_PK AS COST_CENTER_KEY_,
      DEPARTMENT_N_0,
      DEPARTMENT_N_1,
      DEPARTMENT_N_2,
      DEPARTMENT_N_3,
      DEPARTMENT_N_4,
      DEPARTMENT_N_5,
      DEPARTMENT_N_6,
      DOMAIN,
      COST_CENTER_ID,
      COST_CENTER_TYPE,
      COST_CENTER_GIANTS,
      VALID_FROM_DT,
      VALID_TO_DT,
      COST_CENTER_DESC,
      SYSTEM_ID
      FROM
      DWH_COSTCENTER_DIM.qvd
      (
      qvd);

      Temp:
      NoConcatenate
      LOAD
      DWORGD_PK,
      COST_CENTER_KEY
      FROM
      DWH_POSTING_FACT.qvd
      (
      qvd);
      left JOIN(Temp)
      load
      DWORGD_PK,
      COMPANY_ID as COMPANY_ID_CC
      FROM DWH_ORGANIZATION_DIM.qvd
      (
      qvd);

      Left Join ( _COSTCENTER)
      LOAD COST_CENTER_KEY,COMPANY_ID_CC Resident Temp;
      DROP Table Temp;

      FROM
      DWH_COSTCENTER_DIM.qvd
      (
      qvd);

      Temp:
      NoConcatenate
      LOAD
      DWORGD_PK,
      COST_CENTER_KEY
      FROM
      DWH_POSTING_FACT.qvd
      (
      qvd);
      left JOIN(Temp)
      load
      DWORGD_PK,
      COMPANY_ID as COMPANY_ID_CC
      FROM DWH_ORGANIZATION_DIM.qvd
      (
      qvd);

      Left Join ( _COSTCENTER)
      LOAD COST_CENTER_KEY,COMPANY_ID_CC Resident Temp;
      DROP Table Temp;


      DWH_COSTCENTER_DIM:
      NoConcatenate
      LOAD
      DWCC_PK AS COST_CENTER_KEY_,
      DEPARTMENT_N_0 as DEPARTMENT_N_0_CC,
      DEPARTMENT_N_1 as DEPARTMENT_N_1_CC,
      DEPARTMENT_N_2 as DEPARTMENT_N_2_CC,
      DEPARTMENT_N_3 as DEPARTMENT_N_3_CC,
      DEPARTMENT_N_4 as DEPARTMENT_N_4_CC ,
      DEPARTMENT_N_5 as DEPARTMENT_N_5_CC,
      DEPARTMENT_N_6 as DEPARTMENT_N_6_CC ,
      DOMAIN as DOMAIN_CC,
      COST_CENTER_ID as COST_CENTER_ID_CC ,
      COST_CENTER_TYPE as COST_CENTER_TYPE_CC,
      COST_CENTER_GIANTS as COST_CENTER_GIANTS_CC ,
      VALID_FROM_DT as VALID_FROM_DT_CC,
      VALID_TO_DT as VALID_TO_DT_CC ,
      COST_CENTER_DESC as COST_CENTER_DESC_CC ,
      SYSTEM_ID as SYSTEM_ID_CC
      Resident _COSTCENTER
      Where COMPANY_ID_CC ='NL90' and DEPARTMENT_N_2 <> 'IS EMT'
      ;

      Concatenate(DWH_COSTCENTER_DIM)
      LOAD
      DWCC_PK AS COST_CENTER_KEY_,
      DEPARTMENT_N_0 as DEPARTMENT_N_0_CC,
      DEPARTMENT_N_1 as DEPARTMENT_N_1_CC,
      DEPARTMENT_N_2 as DEPARTMENT_N_2_CC,
      DEPARTMENT_N_3 as DEPARTMENT_N_3_CC,
      DEPARTMENT_N_4 as DEPARTMENT_N_4_CC ,
      DEPARTMENT_N_5 as DEPARTMENT_N_5_CC,
      DEPARTMENT_N_6 as DEPARTMENT_N_6_CC ,
      DOMAIN as DOMAIN_CC,
      COST_CENTER_ID as COST_CENTER_ID_CC ,
      COST_CENTER_TYPE as COST_CENTER_TYPE_CC,
      COST_CENTER_GIANTS as COST_CENTER_GIANTS_CC ,
      VALID_FROM_DT as VALID_FROM_DT_CC,
      VALID_TO_DT as VALID_TO_DT_CC ,
      COST_CENTER_DESC as COST_CENTER_DESC_CC ,
      SYSTEM_ID as SYSTEM_ID_CC
      Resident _COSTCENTER
      Where DEPARTMENT_N_2_CC = 'IS EMT' and COMPANY_ID_CC <> 'NL90'
      ;

      DROP Table _COSTCENTER;

      si vous pouvez m'aider merci

        • Re: chargement très long
          Florent Lelarge-Otiniano

          Bonjour Maurice,

           

          s'il tourne sans arrêt, c'est que tu dois avoir une clé de jointure qui se fait sur 2 champs pour lesquels il n'y a pas d'éléments communs, Qvw va alors faire un produit cartésien...

           

          Essaie de vérifier tes noms de champs...

           

          Ensuite, je dirai attention aux espaces dans les noms de champs :

          'IS EMT' remplacé par '[IS EMT]'

           

          Florent.