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
- 16359 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of pivot stage?
how can we create rank using datastage?what is the meaning of rank?
Define meta stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How many types of views are there in a datastage director?
How to read the length of word in unix?
in oracle target stage when we use load option and when we use upsert option?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the main differences you have observed between 7.x and 8.x version of datastage?
Where do the datastage jobs get stored?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What could be a data source system?
What all are the different way to run a job?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Differentiate between operational datastage (ods) and data warehouse?
