1 Reply Latest reply: Jan 18, 2013 8:01 AM by MccM RSS

    Warehouse Builder problem (deploy - package - mapping)

    Dieguinho
      Hi,

      I have a problem with OWB.

      We have two enviroments Development and Test and We deploy a mapping (including all objects) but when we generated the code We have a difference:

      Develpoment:

      CURSOR "AGGREGATOR_c" IS
      SELECT "AGGREGATOR"."CONTEO_RANGOS" "CONTEO_RANGOS"
      +     FROM (SELECT COUNT("AGG_INPUT"."RANGO_CD") "CONTEO_RANGOS"+
      +          FROM (SELECT "TABLE_NAME"."RANGO_CD" "RANGO_CD"+
      +                    FROM "SCHEMA"."TABLE_NAME" "TABLE_NAME"+
      +                    WHERE (EXISTS (SELECT 1+

      +                                        FROM (SELECT MAX("TABLE_NAME"."ACTUALIZACION_REGISTRO_DT") "FECHA_ACT_MAX"+
      +                                                  FROM "SCHEMA"."TABLE_NAME" "TABLE_NAME") "AGGREGATOR_0"+

      +                                                  WHERE ( "AGGREGATOR_0"."FECHA_ACT_MAX" = "TABLE_NAME"."ACTUALIZACION_REGISTRO_DT" )+

      +                                        )+
      +                              )+
      +                    )+
      +"AGG_INPUT" ) "AGGREGATOR" ;+

      Test:

      CURSOR "AGGREGATOR_c" IS
      SELECT "AGGREGATOR"."CONTEO_RANGOS" "CONTEO_RANGOS"
      +     FROM (SELECT COUNT("AGG_INPUT"."RANGO_CD") "CONTEO_RANGOS"+
      +               FROM (SELECT "TABLE_NAME"."RANGO_CD" "RANGO_CD"+
      +                         FROM "TABLE_NAME" "TABLE_NAME"+
      +                         WHERE (EXISTS (SELECT 1 FROM (SELECT MAX("TABLE_NAME"."ACTUALIZACION_REGISTRO_DT") "FECHA_ACT_MAX"+
      +                                             FROM "TABLE_NAME" "TABLE_NAME") "AGGREGATOR_0"+
      +                                             WHERE ( "AGGREGATOR_0"."FECHA_ACT_MAX" = "TABLE_NAME"."ACTUALIZACION_REGISTRO_DT" )+

      +                                             )+
      +                                   )+

      +                         )+

      +"AGG_INPUT" ) "AGGREGATOR" ;+


      We don't have idea how to confgure Warehouse builder to put the database schema of the table...

      Any suggestion?

      Thank you!

      Regards,
      Diego.