Cube Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Topic :: Cube

Cube Interview Questions

Questions Answers Views Company eMail

ORA-30489: Cannot have more than one rollup/cube expression list

1 4283

ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list

1 3231

ORA-06254: NETNTT: cannot share connection to cube

1 2750

ORA-08236: smsget: cannot share subcube with listener

1 2930

ORA-08340: This command not allowed on nCUBE, only one thread is ever used.

1 2658

ORA-08341: On nCUBE, this command can only be executed from instance 1.

1 2909

PLS-00602: CUBE and ROLLUP may appear only in a GROUP BY clause

1 2810

QSM-02028: group by CUBE

1 2806

. The surface area of a cube is 216 sq.m. What is its volume? (a) 100 cu m (b) 216 cu m (c) 480 cu m (d) 512 cu m

1 4093

. The square root of the cube of this number is the cube of its square root. It is not 1 and it is less than 6. What is it? (a) 2 (b) 3 (c) 4 (d) 5

1 3894

can reportnet supports cubes???

IBM, Wipro,

4 9069

how you create security to cubes ?????

iFlex, iGate,

4 9254

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

Satyam,

2 10396

what is a Micro cube?

TCS,

5 13679

How many types of infocubes are there?

3 13553

Related Topics

Cube

Un-Answered Questions { Cube }

What are the steps to load non cumulative cube?

2382

Give examples of data sources that support remote cubes?

2021

How can we Maintain the Cube Security by Category level and Dimension level ?

2320

can cubes contain measures ?

1984

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2057

How to test a cube?

2132

the factorial of non-negative integer n is written n! and is defined as follows: n!=n*(n-1)*(n-2)........1(for values of n greater than or equal to 1 and n!=1(for n=0) Perform the following 1.write a c program that reads a non-negative integer and computes and prints its factorial. 2. write a C program that estimates the value of the mathematical constant e by using the formula: e=1+1/!+1/2!+1/3!+.... 3. write a c program the computes the value ex by using the formula ex=1+x/1!+xsquare/2!+xcube/3!+....

23604

How do we drill through from a powerplay cube to reportnet?\

2299

5. How many repositories can we create in Informatica? 6. What is surrogate key? 7. What is difference between Mapplet and reusable transformation? 8. What is aggregate awareness? 9. Explain reference cursor? 10. What are parallel querys and query hints? 11. DWH architecture? 12. What are cursors? 13. Advantages of de normalized data? 14. What is operational data source (ODS)? 15. What is meta data and system catalog? 16. What is factless fact schema? 17. What is confirmed dimension? 18. What is the capacity of power cube? 19. Difference between PowerPlay transformer and power play reports? 20. What is IQD file? 21. What is Cognos script editor? 22. What is difference macros and prompts? 23. What is power play plug in? 24. Which kind of index is preferred in DWH? 25. What is hash partition? 26. What is DTM session? 27. How can you define a transformation? What are different types of transformations in Informatica? 28. What is mapplet? 29. What is query panel? 30. What is a look up function? What is default transformation for the look up function? 31. What is difference between a connected look up and unconnected look up? 32. What is staging area? 33. What is data merging, data cleansing and sampling? 34. What is up date strategy and what are th options for update strategy? 35. OLAP architecture? 36. What is subject area? 37. Why do we use DSS database for OLAP tools?

2664

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1995

10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?

2444

How do You Maintain a structure after getting cube test of low strength.

2275

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2022

what are the info cube developed in a sap project?name them and what is the requirement?

2800

what is InfoCube?what are the types and uses and in which Case it suppose to be use?

2432