What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

Answer Posted / suresh

surrogate key is alternate to primary key,it allows duplicates also,while maintain the hystorical data we use surrogate key

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are orabulk and bcp stages?

638


Define Job control?

667


What are routines in datastage? Enlist various types of routines.

617


What all the types of jobs you developed?

660


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1619






Difference between sequential file and data set?

632


what is flow of project?

1547


What is process model?

1542


How many types of hash files are there?

601


root tree will find which is server job and which is parallel job?

1438


How you Implemented SCD Type 1 & Type 2 in your project?

3686


What are the stages in datastage?

628


what are the errors,warnings in datastage

2136


What is the difference between Datastage 7.5 and 7.0?

664


Describe stream connector?

817