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
---------------Describe OLAP Reporting and RDBMS Reporting?
Please explain the different stages in creating a report in cognos report net?
Can you define report item?
What is looping and how to avoid it in framework manager?
What are the types of security?
What are the advantages of using cognos sql?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What do you mean by query studio?
Explain informatica architecture?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What are the types of hierarchies?
What is the difference between Standard and Metrics folder?
i have one file i saved in csv how can i take these file into framework manager
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder