which table we load first in DW. dimension or fact? why?
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by the term 'aggregate cache'?
What is the difference b/w macros and prompt?
---------------Tell me about DWH Concepts?
Diff b/w Crossproduct and Outerjoin?
What is zero-foot print?
how to perform single sign in cognos by using url?
What are all the types of gateway used in Cognos?
What is the use of powerhouse?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What are the types of studio?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Define query items?