explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
- 1 Answers
- 1178 Views
- I also Faced
- E-Mail Answers
Answer / Ajay Kumar Singh Yadav
1. Primary Key: A unique attribute or set of attributes that unambiguously identify each record in a table.
2. Foreign Key: A field or fields in one table that refer to the primary key of another table.
3. Business Key: A unique identifier for a business entity, often used as a primary key and derived from meaningful data such as customer IDs, employee IDs, etc.
4. Alternate Key: An attribute or set of attributes that can be used in place of the primary key to uniquely identify each record in a table.
5. Generated Key: A unique value automatically generated by the database management system when a new row is inserted into a table.
6. Retained Key: A type of alternate key where the values are retained even if the corresponding business key changes due to updates or deletions.
7. Surrogate Key: An artificial primary key that has no meaning in the real world but ensures uniqueness across records.
| Is This Answer Correct ? | 0 Yes | 0 No |
how are numeric and character missing values represented internally? : Sas programming
diff between nodup rec and ondup key???
. Which date advances a date, time or date/time value by a given interval?
what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.
What does the trace option do?
How do you generate random samples?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What is the general format of function in sas? : sas-grid-administration
explain about data integrator metadata reports? : Sas-di
Explain what is the use of proc gplot?
Differentiate input and infile.
how can you sort the dataset having millions of OBS(instead of sort procedure?
Teradata 
