Initialization

[Former Member]

Would like to know what are the differences between Initialization with Data Transfer and Initialization without Data Transfer?

Thank you.

[Former Member · Accepted solution]

-init with data transfer sets the delta pointer on the source system side and also transfers all records from source table to BW.

-init without data transfer sets the delta pointer on the source system side but does not transfer any records from source table to BW.BW request shows '0 from 0' records.

Init without data transfer used when..

-u have done full update from source system.And u want to init so that u can do delta later.so dont need to do data transfer init as already full update has sent all data.so u do init with data transfer.

-u also use init without data transfer when some deltas in past few days are gone wrong.u arent able to repair.so u do a full update and then use init without data transfer to reset delta pointer from source system.

cheers,

Vishvesh

[Former Member · Accepted solution]

do full update+init without data transfer when there are large number of records in source tables.

do init with data transfer when no. of records in source table is not very high.

Do any of the above cases..it later can continue with delta loads.

cheers,

Vishvesh

[Former Member]

Hi Mary,

Repair request is used for allowing the

Full repair load is most relevant for ODS, when you want to do a full load from a datasource which has already been initialized and then wants to do a simple full load, the request will not get activated, with the Repair Fullrequest option from the InfoPack->Schedule, you can make the request into Repair full. Which allows the loaded to be activated.

Hope this helps you..

Best Regards,

DMK

*Assign points if it serves your purpose..

[Former Member]

Hello Friends,

I had assigned points to all of you who helped me in understanding about the initialization.

Regards,

Mary

[Former Member]

Hi Sagayah,

Sorry for replying late.

Repair request allows you to do a Full load basing on Selections( with out disturbing the delta loads) So as you are already getting delta's for a give init selections( which can be done as Init without Data trasfer) its the only way to have your delta's coming and even load the Historical Data ( as you will do only Init without data,which enables Delta)

Hope I am clear.

Thanks,

krish

[Former Member]

Hi Mary,

From the details that you have given, It is better to go for Initialization with data transfer (This transfer all your 5 years data) and then create InfoPack for Delta load and then do deltas.

Best Regards,

DMK

*Assign points if it serves your purpose

[Former Member]

Hi DMK,

What are the steps involved if i am doing full load first?

Regards

[Former Member]

Hi Sagayah,

There can be one more scenario for Loading Init with out transfer :

You have data of about 5 years ( which is very huge).

Now your immediate req is to have deltas atleast for current data .

Do a Init Req without Data transfer and then you have deltas daily.

Later load the Repair Reqs ( with Selections) this will also give a performance as you can load requests when the load on server is less on R/3 .

Thanks,

Krish

*Assigning Points is way of saying thanks in SDN!!!!!!!

[Former Member]

Hi Friends,

Let say that I have 5 years of data and I need to load that and also the current delta. What are the steps in involve if I choose Initialization with data transfer and without data transfer?

With Data Transfer

==================

1. Do full load

2. Do init without data transfer

3. Do delta...is that right?

Thanks in advance..

Regards.

[Former Member]

Hi Sagayah,

Since you have to load data for 5 years which is volumenous, it would be better to do full updates for historical data till date using suitable selection(posting date or Document number etc) till date. And then you can do init without data transfer since that date onwards. Then onwards you will get the data in deltas.

Hope this helps

With regards,

Wrushali

[Former Member]

Hi Krish,

Why do I need to load repair request?

Regards,

Mary