This discussion is archived
1 Reply Latest reply: Jan 18, 2013 6:01 AM by MccM RSS

Warehouse Builder problem (deploy - package - mapping)

Dieguinho Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points