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.

Answer Posted / guest

yes we can create cube from multiple iqd's , we have to
first import the primary datasource which contains most of
the structural data item required for the cube creation,
and then other sources,by inserting the data source
separately.
Good practises:
1. we can incrementally update the cube.
2.check the cube status periodically
3.run the test cube with a small amount of data.eg., if you
have 1000 records , we can assign 300 records from each
data source and perform a sample test cube.
4.we can do partition, to improve the runtime performance.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Pivot?

552


What is the difference between a cascading report and drill through the report?

743


How do you call a store procedure within a transformation?

557


dumps needed ASAP for - C2020-180 Cognos IBM Certification

1828


Mention the difference between ‘macros’ and ‘prompt’?

615






We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2091


----------------Diff b/w Dimensional modeling and Relational modeling?

13931


What is the advantage of using shortcuts?

653


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1882


Can you explain new content durability?

582


-----------With out using DrillThrough how to do Reports?

1612


What is meant by drill down?

531


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

1886


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10769


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

1585