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

How rejected rows are managed in datastage?

926


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1703


What are the types of containers and how to create them?

559


What a datastage macro?

639


Difference between server jobs & parallel jobs?

656






Explain the importance of surrogate key in data warehousing?

717


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1754


Nls stands for what in datastage?

729


How can we improve the performance in datastage?

654


Can you explain how could anyone drop the index before loading the data in target in datastage?

900


Explain ibm infosphere information server and highlight its main features?

614


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2277


how to delete one row in target dataset

2588


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2709


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2015