Delta load using 'Date' as selection field in Infopackage

[Former Member]

Hello gurus,

I have about 10million records that are to be loaded into an ODS. I have a field 'date' as a selection field in my Infopackagae. I want to do an 'Init without data' first, and then go with a delta with multiple Infopackages. In this case, can I go with different time periods as a selction option in separate Infopackages while doing a delta.

Example : I have data from 01.2004 to 02.2007

Step 1 :

-

---

Init without data

Step 2 :

-

---

Delta Infopackage 1 with date range 01.2004 - 12.2004

Delta Infopackage 2 with date range 01.2005 - 12.2005

Delta Infopackage 3 with date range 01.2006 - 12.2006

Delta Infopackage 4 with date range 01.2007 - 02.2007

Will this work ?

Thanks

S N

[Former Member · Accepted solution]

hi

Delta will have the selection conditions of ur init load.you can do multiple inits with different date selections. u can use the same info package.

init with date range 01.2004 - 12.2004

init with date range 01.2005 - 12.2005

init with date range 01.2006 - 12.2006

init with date range 01.2007 - 02.2007

delete all initialisations.

i.e infopackage ->scheduler->initialization option of source system.

init.without data transfer ( no selections)

ur delta will bring all the records which has come after this init.

................................................................

or

u can go for full repair request.

do an init. without data transfer.

do full repair with required selections.

ur delta will bring all the records which has come after this init.

hope this helps

regards

biyaz

[Former Member]

Hi,

First load the data with full repair request.In Info packagE -->SCHEDULER-> repair full request. select this option adn load the data in full mode.

After run init with out data transfer.

After that load teh data with deltas.

Assign points if it helps

[Former Member]

hi,

you can go for the delta with different date field in differnent info package after initiallization .

but donot schedule the infopackage at same time since it may write in ods in parellel which may not be permiteed so you amy loose saome data.

pls aassign points if helpful.