problem in delta
Posted: Tue Sep 07, 2004 5:47 am
dear frnds,
i am looking for deltas from source to staging (delta is looked via max(order_id))
where V_ORDERS.ORDER_ID>
(SELECT (MAX(ETL_CONTROL_TABLE_LOAD.MAX_ROW_ID))
FROM E_EXPRESS.ETL_CONTROL_TABLE_LOAD
WHERE ETL_CONTROL_TABLE_LOAD.TABLE_NAME = 'STG_SSWAT_ORDER')
its ok,
i am applying same logic for development it always give me
4 rows less then Staging area.
where STG_SSWAT_ORDER.ORDER_ID>
(SELECT (MAX(ETL_CONTROL_TABLE_LOAD.ROWS_REQD))
FROM DSADMIN.ETL_CONTROL_TABLE_LOAD
WHERE ETL_CONTROL_TABLE_LOAD.TABLE_NAME = 'DIM_SSWAT_ORDER')
its 4 row less everytime
but the the count is same
i was wondering if the count is same from source to staging to development why
the max value is less ,
plz advice ,
Thanxs
bobby
i am looking for deltas from source to staging (delta is looked via max(order_id))
where V_ORDERS.ORDER_ID>
(SELECT (MAX(ETL_CONTROL_TABLE_LOAD.MAX_ROW_ID))
FROM E_EXPRESS.ETL_CONTROL_TABLE_LOAD
WHERE ETL_CONTROL_TABLE_LOAD.TABLE_NAME = 'STG_SSWAT_ORDER')
its ok,
i am applying same logic for development it always give me
4 rows less then Staging area.
where STG_SSWAT_ORDER.ORDER_ID>
(SELECT (MAX(ETL_CONTROL_TABLE_LOAD.ROWS_REQD))
FROM DSADMIN.ETL_CONTROL_TABLE_LOAD
WHERE ETL_CONTROL_TABLE_LOAD.TABLE_NAME = 'DIM_SSWAT_ORDER')
its 4 row less everytime
but the the count is same
i was wondering if the count is same from source to staging to development why
the max value is less ,
plz advice ,
Thanxs
bobby