DELTA
Posted: Mon Aug 16, 2004 1:50 pm
HI ,
I AM SENDING ONE SAMPLE FRP INCREMENT LAOD IS IT OK
PL. GUIDE
SELECT ATS_ACTIVATION.ACCT_NO,
ATS_ACTIVATION.CONVERTER_SERIAL_NO,
ATS_ACTIVATION.RECEIVER_TYPE_ID,
ATS_ACTIVATION.ACTIVATION_TYPE_ID,
TO_CHAR(ATS_ACTIVATION.ACTIVATION_DTE,'YYYY-MM-DD HH24:MI:SS'),
TO_CHAR(ATS_ACTIVATION.CREATED_DTE,'YYYY-MM-DD HH24:MI:SS'),
TO_CHAR(ATS_ACTIVATION.LASTMODIFIED_DTE,'YYYY-MM-DD HH24:MI:SS'),
ATS_ACTIVATION.ETL_CONTROL_KEY,
TO_CHAR(SUBSCRIBER.CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS')
FROM #$SOURCE_SCHEMA#.ATS_ACTIVATION ATS_ACTIVATION,
#$SCHEMA_CCS#.SUBSCRIBER SUBSCRIBER
WHERE ATS_ACTIVATION.ACCT_NO = SUBSCRIBER.ACCT_NO (+) AND
TO_CHAR(ATS_ACTIVATION.CREATED_DTE,'YYYY-MM-DD HH24:MI:SS') >
(SELECT MAX(TO_CHAR(ETL_CONTROL_TABLE_LOAD.MAX_EXTRACT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS'))
FROM #$CONTROL_SCHEMA#.ETL_CONTROL_TABLE_LOAD
WHERE ETL_CONTROL_TABLE_LOAD.TABLE_NAME = 'STG_ATS_ACTIVATION')
I AM SENDING ONE SAMPLE FRP INCREMENT LAOD IS IT OK
PL. GUIDE
SELECT ATS_ACTIVATION.ACCT_NO,
ATS_ACTIVATION.CONVERTER_SERIAL_NO,
ATS_ACTIVATION.RECEIVER_TYPE_ID,
ATS_ACTIVATION.ACTIVATION_TYPE_ID,
TO_CHAR(ATS_ACTIVATION.ACTIVATION_DTE,'YYYY-MM-DD HH24:MI:SS'),
TO_CHAR(ATS_ACTIVATION.CREATED_DTE,'YYYY-MM-DD HH24:MI:SS'),
TO_CHAR(ATS_ACTIVATION.LASTMODIFIED_DTE,'YYYY-MM-DD HH24:MI:SS'),
ATS_ACTIVATION.ETL_CONTROL_KEY,
TO_CHAR(SUBSCRIBER.CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS')
FROM #$SOURCE_SCHEMA#.ATS_ACTIVATION ATS_ACTIVATION,
#$SCHEMA_CCS#.SUBSCRIBER SUBSCRIBER
WHERE ATS_ACTIVATION.ACCT_NO = SUBSCRIBER.ACCT_NO (+) AND
TO_CHAR(ATS_ACTIVATION.CREATED_DTE,'YYYY-MM-DD HH24:MI:SS') >
(SELECT MAX(TO_CHAR(ETL_CONTROL_TABLE_LOAD.MAX_EXTRACT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS'))
FROM #$CONTROL_SCHEMA#.ETL_CONTROL_TABLE_LOAD
WHERE ETL_CONTROL_TABLE_LOAD.TABLE_NAME = 'STG_ATS_ACTIVATION')