Diff b/w surrogate Key and Primary Key?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

2087


Can you explain dynamic query mode?

592


can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1717


Can you define snapshot?

558


What is looping and how to avoid it in framework manager?

670






Why cognos decision stream is used?

640


What is zero-foot print?

598


What is the function of model design accelerator?

539


how to perform back drill through in cognos 8 what is the use of it

2036


What are the types of hierarchies?

562


What are all the types of hierarchies?

677


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1664


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1553


Can you explain cognos planning?

671


Why are meta service important then other services?

588