2 Replies Latest reply: Feb 17, 2014 4:40 AM by Raj2188 RSS

    Last Extract Date defaulting to 01-01-1753

    SYedurur

      Hi My last Extract Date from DAC is being overridden by 01-01-1753,I tried  setting overrideMpltVarWithMapVar = YES.Below is the parameter file being generated.It is passing null value instead of last run time.Please advise what needs to be done for the setting up of incremental load.

       

      $$ALIGNMENT_VER=Y

      $$ANALYSIS_END=01/01/2011 12:59:00

      $$ANALYSIS_END_WID=20110101

      $$ANALYSIS_START=12/31/1979 01:00:00

      $$ANALYSIS_START_WID=19791231

      $$CURRENT_DATE=02/10/2014

      $$CURRENT_DATE_IN_SQL_FORMAT=TO_DATE('2014-02-10', 'YYYY-MM-DD')

      $$CURRENT_DATE_TIME_IN_SQL_FORMAT=TO_DATE('2014-02-10 13:44:34', 'YYYY-MM-DD HH24:MI:SS')

      $$CURRENT_ETL_START_TS=TO_DATE('2014-02-10 13:44:08', 'YYYY-MM-DD HH24:MI:SS')

      $$CURRENT_QUARTER=2014 Q 1

      $$DATASOURCE_NUM_ID=1

      $$DEFAULT_LOC_RATE_TYPE=Actual

      $$DFLT_CONTINENT=North America

      $$DFLT_COUNTRY=USA

      $$DFLT_LANG=ENU

      $$ETL_PROC_WID=23200965

      $$GLOBAL1_CURR_CODE=USD

      $$GLOBAL1_RATE_TYPE=Actual

      $$GLOBAL2_CURR_CODE=USD

      $$GLOBAL2_RATE_TYPE=Actual

      $$GLOBAL3_CURR_CODE=USD

      $$GLOBAL3_RATE_TYPE=Actual

      $$HI_DATE=TO_DATE('3714-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')

      $$HI_DT=01/01/3714 12:00:00

      $$Hint_Tera_Post_Cast=

      $$Hint_Tera_Pre_Cast=

      $$INFA_LOAD_DT=02/10/2014 13:44:09

      $$INITIAL_EXTRACT_DATE=01/01/1900

      $$JULIAN_LOAD_DT=2456699

      $$LANGUAGE_CODE=E

      $$LAST_EXTRACT_DATE=

      $$LAST_EXTRACT_DATE_IN_SQL_FORMAT=

      $$LAST_TARGET_EXTRACT_DATE_IN_SQL_FORMAT=TO_DATE('2014-02-09 12:17:56', 'YYYY-MM-DD HH24:MI:SS')

      $$LOAD_DT=TO_DATE('2014-02-10 13:44:09', 'YYYY-MM-DD HH24:MI:SS')

      $$LOAD_DT_WID=20140210

      $$LOV_MAX_VAL=9999999999

      $$LOV_MIN_VAL=0

      $$LOW_DATE=TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')

      $$LOW_DT=01/01/1899 00:00:00

      $$MASTER_CODE_NOT_FOUND=

      $$MAX_DAYS_IN_STG=30

      $$MLOV=N/A

      $$PRUNE_DT=TO_DATE('2014-02-09 13:44:09', 'YYYY-MM-DD HH24:MI:SS')

      $$PRUNE_DT_WID=20140209

      $$SNAPSHOT_DT_WID=20140210

      $$SOURCE_CODE_NOT_SUPPLIED=