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

What is the difference between datastage and datastage tx?

692


What are routines in datastage?

920


Give an idea of system variables.

685


table actions available in oracle connector?

1202


What are the types of views in datastage director?

1396






What are datastage sequences?

777


What is the command line function to import and export the ds jobs?

780


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

710


Define project in datastage?

761


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1699


How to perform incremental load in datastage?

766


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

850


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

685


how to add a new records into source?

1610


What is a merge?

757