Diff b/w surrogate Key and Primary Key?
Answers were Sorted based on User's Feedback
Answer / uma
Primary keys are used in OLTP whereas surrogate keys are used in OLAP schemas.PKs hold some business meaning whereas SKs does not hold.PKs contain both numeric as wellas non numeric values whereas SKs contain only simple numeric values.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / krishna
surragate key is a system generated primary key.
| Is This Answer Correct ? | 4 Yes | 1 No |
what is Associated grouping? and how it works in cognos impromptu?
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos
Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....
Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me
What is Conditional block? How do you use in a report?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
What are the types of hierarchies?
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
Is it possible to create drill through access to other report from PDF report?
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.
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
Explain the Difference Between Bursting and Scheduling?