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 / 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 all the types of jobs you developed?
What are the difference types of stages?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
options available in sequence job to run,validate?
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 different type of jobs in datastage?
what is use of SDR function?
What is the difference between an operational datastage and a data warehouse?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to find value from a column in a dataset?
Define orabulk and bcp stages?
What are stage variables?
What is the use of hoursfromtime() function in transformer stage in datastage?
Describe link sort?
Terminate Activity