What is surrogate key?

Answer Posted / nivas

Surrogate key is a system generated sequence numbers. It is
also called artificial key.Sarrogate key using as a primary
key without using sarrogate key we can't do SCD type2
implemenation.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is workflow? What are the components of workflow manager?

711


What is a rank transform?

676


What are the types of schemas we have in data warehouse and what are the difference between them?

525


What is informatica etl tool?

556


How to handle decimal places while importing a flatfile into informatica?

727






How are indexes created after completing the load process?

987


Explain sessions and how many types of sessions are there?

586


What is data movement mode in Informatica and difference between them?

624


expain about the tune parameters?

1890


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1974


have u done any performance tuning? how u ll do?

1861


What is the Rank index port in Rank transformation?

672


What is informatica? Why do we need it?

643


How can a transformation be made reusable?

665


What are connected or unconnected transformations?

630