Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 7711 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
Can you explain cognos planning?
What is a Framework manager?
What is meant by Reportstudio shortcut?
What are all the components of Report Studio?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
Can you define materialized view?
What do you understand by the term 'aggregate cache'?
What are initial page components of Cognos connection?
how to connect datamarts
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 are slice and dice?
How can I schedule reports in cognos?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
