What is the use of surrogate key stage?

Answer Posted / vinod upputuri

Surrogate Key Stage is used to generate the Surrogate Key.

the main purpose of the Surrogate key is to maintain the
complete history in the dimension tables.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which commands are used to import and export the datastage jobs?

981


What is the use of datastage director?

588


Define repository tables in datastage?

701


If you want to use the same piece of code in different jobs, how will you achieve it?

634


How complex jobs are implemented in datstage to improve performance?

596






how to sort two columns in single job in datastage.

2529


How to manage date conversion in Datastage?

640


How can you write parallel routines in datastage PX?

618


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

538


what is the custome stage in datastage? how can we impliment that one? plz tell me

1909


what is 'reconsideration error' and how can i respond to this error and how to debug this

2119


Demonstrate experience in maintaining quality process standards?

1933


What are the different plug-ins stages used in your projects?

623


Can you explain engine tier in information server?

652


Whats difference betweeen operational data stage (ods) and data warehouse?

669