How to generate surrogate key without using surrogate key stage?

Answer Posted / murali

yes ur right but we have another way to generate s key by
using transformer .in transformer we have a surrogate key tab
click the skey tab in that we hav state file and db sequence
these r used for generate and hold the s key value

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How complex jobs are implemented in datstage to improve performance?

610


explain about citrix scheduling tool in datastage

1820


How a server job can be converted to a parallel job?

634


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1767


What are the different type of jobs in datastage?

619






How to perform incremental load in datastage?

686


Explain the datastage parallel extender (px) or enterprise edition (ee)?

747


What all are the different way to run a job?

652


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4580


what is ds administrator used for?

734


How to reverse the string using unix?

2825


What are routines in datastage?

795


What are the repository tables in datastage?

845


What are the features of datastage flow designer?

647


What is the difference between orabulk and bcp stages?

590