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
What is main difference mapplets and mapping?
What is the difference between ‘macro’ and ‘prompt?
Define the slice and dice?
Why cognos scenario is used?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What is meant by junk dimension?
What junk dimension contains?
Can you define folder?
explain how to create powerplay reports?
What is difference between content store and content manager?
What are the advantages of shortcuts?
What is the advantage of using shortcuts?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how to merge 2 crosstabs thans
What is the model filter?