1 Reply Latest reply: Aug 21, 2017 8:26 AM by Ahmed El Midaoui RSS

    Synthetic Keys Issue

    Ahmed El Midaoui

      Hello friends,

      I am facing a problem with synthetic keys, and memory.

       

      what I want is to create keys (but not synthetics ones) between the tables. The alternative of using 'concatenate' before the LOAD statement transforms the model to one table. The problem is the number of tables I need to load (12 tables), I cannot use concatenate because of the memory problem (imagine all the tables concatenated into one, the execution would be very slow) .

       

      Here is my script:

       

      SET ThousandSep=' ';
      SET DecimalSep=',';
      SET MoneyThousandSep=' ';
      SET MoneyDecimalSep=',';
      SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
      SET TimeFormat='hh:mm:ss';
      SET DateFormat='DD/MM/YYYY';
      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
      SET FirstWeekDay=0;
      SET BrokenWeeks=0;
      SET ReferenceDay=4;
      SET FirstMonthOfYear=1;
      SET CollationLocale='fr-FR';
      SET CreateSearchIndexOnReload=1;
      SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
      SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
      SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
      SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';


      LIB CONNECT TO 'ole db';

      LOAD `A/C Family`,
          CDT,
          `Champ_NEO`,
          `Commodity group`,
          `Commodity PROC`,
          `Cons MRP Controller`,
          `Cons Ordering Org`,
          `Consumer Plant`,
          Field10,
          Field12,
          Field15,
          Field17,
          Field22,
          Field24,
          Field26,
          Field29,
          Field5,
          Field7,
          `Fulfilment Rate`,
          `Indicator: Critical`,
          Location,
          Material,
          `Missing char`,
          `Nb MP`,
          `Nb MP 7 days`,
          `Nb WOL 7 days`,
          Plant,
          Program,
          `Program Family`,
          `Prov MRP Controller`,
          `Prov Ordering Org`,
          `Requirement Date`,
          `Requirement Week`,
          Station,
          `Storage Location`,
          `Supplier Type`,
          Vendor,
          `Work Order Material`,
          `Work Order Number`,
          `Work order type`,
          `Work Package`;

       

      FROM `Req_FR`;

       

      LOAD `A/C`,
          `A/C Family`,
          Cat,
          CDT,
          `Consuming Plant`,
          `Consuming Plant Desc`,
          `Days Missing`,
          `Entité client`,
          `Entité responsable`,
          `Fab_Element`,
          `Flux Tiré Cons`,
          `Flux Tiré Fourn`,
          `Fourn# Ordering Org#`,
          `LEGACY Prog`,
          `Ligne de produit`,
          Material,
          `Material Desc`,
          `Missing Qty`,
          `MP Date Range`,
          `MP Flag Set Date`,
          `MRP Controller client`,
          `MRP Controller client Desc`,
          `MRP Controller responsable`,
          `MRP Controller responsable Desc`,
          MSN,
          `Nb j en Mqt`,
          `Part_type`,
          `Pièce Critique`,
          Plant,
          `Product_Line`,
          Program,
          `Program Family`,
          `Qté Mqt`,
          `Required Quantity`,
          `Requirement Date`,
          `Reservation Item`,
          `Reservation No`,
          `SAP_system`,
          Semaine,
          `Site client`,
          `Station (incl stage)`,
          `Storage Location`,
          `Supplier Type`,
          `TOTAL`,
          `Type APPRO`,
          Vendor,
          `Week`,
          `Work Order Material`,
          `Work Order Material Desc`,
          `Work Order Number`,
          `Work Order type`,
          `Work Package`;

       

      FROM `Req_MP`;

       

      the model

       

      Capture.JPG