What is the size of the cube in ur project?what is the complex report u created in ur project and explain?how dimensions u have in ur project and how many facts?I am new to this dwh. so can anybody give the answers to the above?

Administrator wrote on Monday, 21 May 2007 01:48:53:
-- test

Interview Candidate
Sep 27th, 2006
18
4609

Showing Answers 1 - 18 of 18 Answers

sivakumardwh
Profile Answers by sivakumardwh Questions by sivakumardwh

Nov 13th, 2006

Hi vasanth
i am siva(cts)
in each project we have create different types of cubes each have diff size for exp first cube size is 1,20,380 kb like that each have diff in size

sivakumardwh
Profile Answers by sivakumardwh Questions by sivakumardwh

Nov 13th, 2006

depends upon the projects its vary for exp you take sales analysis prj total dim:45 & facts:8 all are star schema

vasanth

Dec 6th, 2006

Hi, siva
vasanth here. thanks for answer. but i heard that maximum size of the cube is 2gb. can u pl tell me maximum how many dimensions we can have in a project. i think 45 dimensions its wrong

RANGA

Jan 3rd, 2007

in past versions(7.1) we have to create upto 2GB.now we can create more than 2GB also.
in schema no limitation for no.of dimensions and fac tables, depends on our model.