which table we load first in DW. dimension or fact? why?
Answer Posted / asish mohapatra
We should first load dimension table then the fact table .
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Which lifecycle we will use for reporting?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
Please explain the different stages in creating a report in cognos report net?
What is catalog and types of catalogs in cagonos and which is better?
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?
what are the dimensions that you have in your current project?list them?
What are various types of gateways in cognos?
Define olap designer?
Define query studio?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
i have one file i saved in csv how can i take these file into framework manager
faq's on cognos
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?