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?
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 |
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
What is the default padding character?
how to closeing records after 10,000 records come?
What is the difference between operational data stage (ods) and data warehouse?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
How to implement complex jobs in data stage?
Difference between data warehousing and olap?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
what is the unix script to run the job? Please mention commands which we use often?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output