what is surrogate key give example?

Answer Posted / pavan kumar

A Surrogate Key is a system generated sequence numbers to
be used as primary keys.
A Surrogate keys are used in maintaining the full history
in scd type2.
A Surrogate key is also known as Synthetic Key or
Artificial Key or Dimensional Key.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain the different stages in creating a report in cognos report net?

559


Can you define folder?

557


What is drill down and slicing and dicing whats the difference between them?

540


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1866


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

1620






how to merge 2 crosstabs thans

2143


Can you define a query subject?

603


What is main advantage datawarehousing over oracle?

554


What is difference between informatica power mart and power center?

558


What actually a project contains?

637


What is the difference between group and associare?

587


---------------Tell me about DWH Concepts?

1603


What is meant by alternate drill down with ex?

617


which type of project we r going to snowflake schema

1594


what are the names of the reports that you prepared?

620