on 06-11-2011 8:49 AM
Hi,
Pre-Requisite Requirement : I want to partition my large cube(contains 4 Cr records). So I proceeded as the following
I carried out the Creation of a copy of my existing Cube and loaded data to my new copy cube. Before partitioning the original cube, I need some clarifications on the following :----
1. In the course of creation of Copy of my Cube, I created Transformation and DTP. After this, I loaded data from Original Cube to Copy cube, but there was no Infopackage to run. I just ran Full load in DTP which got the entire data from original to Copy cube. Is it correct?
2. After I partition my original cube and try to load yearwise, How should I put selection year range without Infopackage between Original to Copy?
Please clarify me for the above........
Regards,
Suman
1. Yes it is correct
2. Create a transformation between you Original Cube and Copy Cube.
Original cube should be your target and Copy cube should be your source for transformation.
and then create a DTP for the newly created transformation. IF you want to load year wise, use selections in DTP filter.
--- Thanks...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Guys
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.