Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17851 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kpk
Pass the last key (last primary key or the last value in the
seq) as parameter.
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / 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 |
Answer / 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 |
what is meta data? Explain? Where it is used?
how can u connect the client system directly at any time?
How can you join flat file, oracle as a sources?
What are the different kinds of views available in a datastage director?
whats difference between ls -ltr and ls -lrt?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
What is the difference b/w Hash file and Lookup Fileset stages?
What is the function in Transformer stage can act as Rank Function in oracle
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?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between datastage and datastage tx?
Teradata 
