What is the use of surrogate key stage?

Answers were Sorted based on User's Feedback



What is the use of surrogate key stage?..

Answer / shar

Here are Uses:
1.We can generate sequence Numbers.
2.This will act as alternative to primary key.
3.we can pass the values with parameters.
4.we can pass the parameters at run time.
5.parameterization is possible.

cool...:)

Is This Answer Correct ?    1 Yes 0 No

What is the use of surrogate key stage?..

Answer / 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

More Data Stage Interview Questions

How many types of hash files are there?

0 Answers  


how to create document in datastage?

1 Answers   Cap Gemini,


what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,


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

0 Answers   TCS,


Which algorithm you used for your hashfile?

0 Answers  






How complex jobs are implemented in datstage to improve performance?

0 Answers  


how can we do null handling in sequential files

2 Answers   Reliance,


What are the main features of datastage?

0 Answers  


What are the functionalities of link collector?

0 Answers  


How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  


What are the different common services in datastage?

0 Answers  


1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,


Categories