Generic extractor using date as delta

[Former Member]

Hi folks,

I have 2 questions that are related to Generic datasource having date as the delta specific field.

1. When INIT load is performed for this extractor, what is the start date it uses? there is no value in Safety Intervals so I would think it uses the current date only. If this is true, how do we get this extractor to start from, say start of the year? Or is this not possible with the INIT?

2. When FULL LOAD is performed on this extractor, does it append any criteria that is related to the date field on which delta has been enabled? or completely ignores it? Just looking for a confirmation.

THanks.

[Former Member]

Hi

1. When INIT load is performed for this extractor, what is the start date it uses? there is no value in Safety Intervals so I would think it uses the current date only. If this is true, how do we get this extractor to start from, say start of the year? Or is this not possible with the INIT?

Generic delta on date works on calendar day. When we run init system take current day(system date) as delta pointer. we can not change this.

2. When FULL LOAD is performed on this extractor, does it append any criteria that is related to the date field on which delta has been enabled? or completely ignores it? Just looking for a confirmation.

It will not consider on which delta is created, it will load complete data. If you need any specific data, then run full load with selections(make this as full repair, if you have active delta on data source)

Regards,

Venkatesh

[anindya_bose]

Hi Intel

1. When INIT load is performed for this extractor, what is the start date it uses? there is no value in Safety Intervals so I would think it uses the current date only. If this is true, how do we get this extractor to start from, say start of the year? Or is this not possible with the INIT?

INIT load is like a full load only, difference is it sets the delta pointer i.e it keeps the information that till this date ( or time) I have extracted.

regarding safety delta if your upper safety limit is 2 hours and current time is 12 o clock , it will fetch till 10 o clock from the beginning. Lower safety delta does not play any role in case of init. Because if your oldest date is 01/01/1999 , then lower delta will make the selection from 01/01/1999 - 2 = 29/12/1998.

2. When FULL LOAD is performed on this extractor, does it append any criteria that is related to the date field on which delta has been enabled? or completely ignores it? Just looking for a confirmation.

Extractor checks the update mode of the extraction, in case of Delta only it uses selection previously saved. For full load it does not check that

For good understanding check the code of FM RSAX_BIW_GET_DATA

Regards

Anindya