Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 7705 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
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 is hints in cognos and where we use it.
What you mean by drill across?
How is cognos model organization works?
explain how to create powerplay reports?
What is the difference between regular dimension and derminant?
Name the types of gateway?
What is the difference between a cascading report and drill through report?
What is Metrics designer?
Is it possible to join multiple Databases in a Catalog?
What are all types of Batches?
What is the difference between ‘macro’ and ‘prompt?
------------------What is Inline Query?
What is meant by Reportstudio shortcut?
Can you define drill down and drill up?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
