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 / prasad
this type of problem is clear in datastage8.0.1 version by
using the new surrogate key generator stage.
But whenever we use below 8th version we can will face the
problem in the case of surrogate key.to overcome this
problem use the help of the routines.
we have to pass the maximumvalue of the surrogate key
through the routine.when ever we run the job second time the
routine will pass the max value and it will generate the
sequence from that number only
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the various kinds of the hash file?
What is datastage engine?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How to clean the datastage repository?
how to abort the job its matain duplicates?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Which commands are used to import and export the datastage jobs?
How you Implemented SCD Type 1 & Type 2 in your project?
Which warehouse using in your datawarehouse
what is the use of skid in reporting?
Where the datastage stored his repository?
What is use Array size in datastage
Enlist various types of routines in datastage.
How you can fix the truncated data error in datastage?