Rapid mart Delta mode $G_SDATE override

dataservices rapidmarts
1

Hi,

I would like to run a rapid mart in Delta Mode to bring in data for only this month. I need to do this on our development system.
By default Rapid Mart resets global variable SDATE as previous run date -1. The last time this rapid mart was run in this development system was in Feb 2012. I do not want to bring in huge volume but at the same time test it in Delta mode.

How do I override the $G_SDATE to 03/01/2013 in Delta mode?

Thanks…

Diana_baker (BOB member since 2005-03-18)

2

Hi Diane

[I’m new to Rapid Marts]

Isn’t it simply a matter of changing the $G_SDATE to be ‘2013.01.03’ with the $G_LOAD_TYPE set to ‘DELTA’?

If this is wrong then any advice on why is appreciated.

:?

Imran Hussain :uk: (BOB member since 2013-03-18)

3

Hi Imran,

Even if you set the global variable $G_SDATE = ‘2013.03.01’, the rapid mart inbuilt function AW_Start will over writes this date based on the last successfull run date which in my case is in Feb 2012.

I did some more research and found that the table which stores these dates is ‘AW_JOBEXECUTION’. Since this is development server, I am planning to update the row for this job. The column to update is EXTRACTHIGH (which stores the last successfull run date).

Though, this seems to work as I intended, the better way is to see if i can override this date in the BODI Designer script itself…which at this time I am not sure how to do that.

Thanks…

Diana_baker (BOB member since 2005-03-18)

4

Hi Diana

I was looking into this further and I think the $G_RUN_MODE will be your point of call:

"RESET - Forces job to reload from value set in $G_SDATE.
NULL - Uses AW_JOBEXECUTION to determine $G_SDATE.
When set to “RESET”, this variable forces the Rapid Mart to use the starting extract date you have set for variable $G_SDATE. Otherwise, the setting is determine by querying table AW_JOBEXECUTION, and using the EXTRACTHIGH value of the last successful run. "

It’s default is NULL.

Hope that helps

Cheers

Imran Hussain :uk: (BOB member since 2013-03-18)

5

Interesting! Never used $G_Run_Mode. I will try that some time.
Thank you Imran!

Diana_baker (BOB member since 2005-03-18)

6

Yes, that will do it.

craiggsmith (BOB member since 2009-06-01)