Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

in u r data u having duplicates how to fetch the latest data in our report?

5631


How to test a cube?

2127


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2358


--------------Explain Table of contents?

1970


What are query items?

971


What is a Transformer?

1026


What is meant by Reportstudio shortcut?

2126


How can I test reports in cagonos?

904


which type of project we r going to snowflake schema

1929


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4521


What is the function of cognos dispatcher?

1141


Explain what is the difference between native sql and cognos sql?

938


What is the deployment requirements used in cognos?

1593


What is an olap designer?

914


What are the different uses of a repository manager?

1023