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
- 16367 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 |
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?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
What is a datastage job?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
how to capture rejected data by using join stage not for lookup stage. please let me know
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how many types of remove the duplicate records?
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
What is difference between symmetric multiprocessing and massive parallel processing?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
Teradata 
