which table we load first in DW. dimension or fact? why?
Answers were Sorted based on User's Feedback
Answer / asish mohapatra
We should first load dimension table then the fact table .
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / krishna
First we load dimension and next fact. Without dimension table there is no meaning for fact table.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / adnan
Fact table has foreign keys referencing the primary key of dimension.
Logically Foreign key is a subset of primary or unique key. That's why , we
need to load dimension tables first and then to load fact tables.
Is This Answer Correct ? | 0 Yes | 0 No |
difference between join and union in reportstudio?
What is a Query Subject?
where we use page break and page set. with example?
What are the roles defined by cognos platform?
When we save a report in report studio with what extn it save?
What are various types of gateways in cognos?
What are all the types of gateway used in Cognos?
can you apply grouping on crosstab?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
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.