on 06-25-2008 4:07 AM
We are loading 2lis_03_bf to ODS.
Then from the ODS, request is sent to the InfoCube
Now I need to Compress the InfoCube.
Which request do I Compress ?
I have earlier an INIT without Data Transfer to InfoCube, thereafter all are Delta's.
Please kindly advice.
Hi,
Is the cube also includes any other data other than 2LIS_03_BF!
If the answer to the above question is 'No', then there is no restriction on compression and you can go ahead and compress the data..
If the answere to the above question is 'Yes' and the cube also
holds data belongs to data source '2LIS_03_BX' then compression has to be planned carefully and here is the sequence:
- Compress the 'Opening Stock' - INIT request
with 'Marker' update
- Compress the 'BF' - INIT request withut 'Marker update'
- Delta loads from 'BF' are compressed with 'Marker
update'
Hope this helps.
Bala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris,
We do compression of the request for the performance point of view. There is as such no limitation for number of requests to be compressed, you can compress all of your requeset.
It depends on the number of records that ur getting in delta daily, if they are not too high you can avoid doing compression. But usually init request is compressed always.
Thanks
Dipika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.