on 06-15-2011 8:30 AM
I have enhanced the standard datasource with 2 new fields and moving to PROD,where Processchain for Delta load is daily getting loaded(without enhancements).Existing cube in Prod has 8 crores of records.
After ECC DS Transport,replicate to BW and BW objects Transport INCLUDING Datasource.
Loading options:
1.Delete data (I need historical dat for the enhanced field) from the cube,DO FULL LOAD and DELTA INIT WITHOUT DATA TRANSFER.
2.Delete Data,REPAIR FULL REQUEST without any filters,and run the existing delta process chains(delta will take care).
3.Delete Data,INIT With Data Transfer and run the existing delta process chains.
4.Run FULL IP,Delta init without data transfer and run the existing delta process chains.
Which option should I follow?is there any difference between full load and delta init with data transfer?
Thanks
TG
The only difference between Full and Init with data transfer opiton is that the latter will create a delta queue in the source system for your datasource apart from pulling the entire data.
To be simple Delta will be enabled if you do Init with data transfer.
And if you need history data for the enhanced fields then you have to delete the contents for your target and then you have to do a full load.
The Best way is to perform Init without data transfer and then a Full load.
Since init with data transfer takes more time to complete and if it fails in between then you have to restart the process again.
So perform Init without data transfer and then do a Full load.
--- thanks..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If I follow Init without Data transfer and Full load means sure it will corrupt the delta Queue(thats why ful repair request getting used)
I think it should be Full load and Init without data transfer and delta loads.
Anymore thoughts plsss...since I am going to perform this in PROD with crores of records.
Thanks
TG
Requesting you to clarify my doubts
If you perform Full load and then Init without data transfer then you might end up losing records which were posted during Full load.
Say I did full load on June 1 9 PM(it picked up data till JUNE 1st - Posting stopped at 5PM) and Delta intilize ON June 1st 10 PM without data transfer(delta initilise),June 2nd 9PM triggered the process chain and it picked up June 2nd Data.Same set i will do for today.If we do full load it will pickup as on date record,init and delta,then how its possible for data loss.
Thanks
TG
If you are sure that no posting would happen when you perform your Full load then there is nothing to worry.
you can do Full load -> initialize delta -> schedule PC for delta loads.
Say in case if there are chances of user posting some entries during the Full load, then you might lose those records which were posted duirng the full load(As per example above Full load occurs between 9pm to 10pm, if user post any data during these period then those will not be captured neither in the Full load nor in the delta load and you might end up losing those records.).
Hope it is clear for you now.
--- Thanks...
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.