cancel
Showing results for 
Search instead for 
Did you mean: 

ODS data loading

gavin_gu
Participant
0 Kudos

Hi experts,

We have an init request and many delta requests in ODS. When I want to do an init data loading again. Do I need to delete the existing requests in ODS? Why? Thank you.

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

Gavin,

It is not possible to run the INIT once after you run the delta loads, but i dont know why you are looking for INIT run when the system is running with the delta loads. If you really wnat to run INIt then you need to delete the data and then you need to delete the INIT request in IP screen, then once again you can run the INIT.

Assign Points if it helps..

Thanks,

Gattu.

Former Member
0 Kudos

You have two options if you delete the delta init (in the infopackage) but not the request, then you can do a init without data records and next the delta would be working...or you can delete all the data of the ODS and reload all...

In both cases you must delete the init delta

Regards

gavin_gu
Participant
0 Kudos

Hi KISHORE M REDDY,

You mean I just need to delete init-flag for datasource , instead of requests, Right?

Thank you.

former_member185071
Contributor
0 Kudos

Hi Gavin Gu

No In Infopackage scheduler menu u will get a option for initialisation option for

source specific just clcik on it it will show u a pop up wher u can find a request

just delete it . Then come bak to package screen go to update tab jus selct init

option make sure abt the check box with out data transfer and then schedule it

then again come back to info package and then go to update now u can see dleta

pointer just select the pointer and save it so that next time onwordz it will pick the

delat records with out distrubing the previous data..

Hope itz Helps..!

Regards

KISHORE M REDDY

**Winners Don't Do Different things,They Do things Differently...!**

> Hi KISHORE M REDDY,

>

> You mean I just need to delete init-flag for

> datasource , instead of requests, Right?

> Thank you.

Former Member
0 Kudos

Hi Gavin,

Deleting the requests in the ODS and then doing an init load with data transfer is the better idea. But in case you really have to keep the old requests for some reasons, you may perform first a "full repair" load before you do a init without data transfer. This helps ensuring data consistency between your ods and the source before initializing it again.

Hope this helps.

Regards,

Randy

former_member185071
Contributor
0 Kudos

Hi Gavin Gu

You should delete the init Y bcz its a source system specific.

If already delats are running then u can just delete the existing init req and then do

an init w/o data transfer.So that from next load onwords it will set up the delat w/o

any struck ups.

Hope itz Helps..!

Regards

KISHORE M REDDY

**Winners Don't Do Different things,They Do things Differently...!**

> Hi experts,

>

> We have an init request and many delta requests in

> ODS. When I want to do an init data loading again. Do

> I need to delete the existing requests in ODS? Why?

> Thank you.

Former Member
0 Kudos

Yes you have to delete the requests as the Initialization is set once & deltas were loaded.

Also you have to delete the "Initiazation in the Source System" - Infopackage - Scheduler to do Init again.

Former Member
0 Kudos

Hi Gavin,

Yes , if you want to do Init again means.. you need to delete the data.. but.. once you load the deltas.. after init is not suggestable.. that's why it wont support..

you shold delete the data and do INIT.... becaus ethe name itself.. INIT means ..Initially we are doing this step..

regards

@jay

Former Member
0 Kudos

It is not possible to do init once more after running Deltas.

If you want to do the init request you have to delete the existing requests because once you had run Delta load it won't accept to run Re-init.

Hope it will helps you......