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?
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 to implement complex jobs in data stage?
Have you used Unstructured data?
How one source columns or rows to be loaded in to two different tables?
Demonstrate experience in maintaining quality process standards?
Explain the situation where you have applied SCD in your project?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
On which Dimension Table you implemented SCD Type in your Project
Enlist various types of routines in datastage.
What is aggtorec restructure operator?
what are the errors,warnings in datastage
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Highlight the main features of datastage?
How can you write parallel routines in datastage PX?
How do u convert the columns to rows in datastage?