HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING
SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT
EVEN IF THE JOB IS COMPILED REPEATEDELY?
- 4 Answers
- 16320 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / kiran
If you want the SCD stage to generate new surrogate keys by
using a key source that you created with a Surrogate Key
Generator stage, you must use the NextSurrogateKey function
to derive the Surrogate Key column.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How we can covert server job to a parallel job?
Is it possible to query a hash file?
What all are the different way to run a job?
What is active and passive stage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
how to export or import the jobs in .ISX file
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the steps needed to create a simple basic datastage job?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the some differences between 7.x and 8.x version of datastage?
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?
What are the stages in datastage?
Define APT_CONFIG in Datastage?
Define Data Stage?
How do you import and export the datastage jobs?
