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
Why do we use exception activity in Datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is data partitioning?
What is use Array size in datastage
Name the different sorting methods in datastage.
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the difference between in process and inter process?
Can you highlight the main features of ibm infosphere information server?
How can one find bugs in job sequence?
How a routine is called in datastage job?
which r the connectors used in san?
What are the difference types of stages?
What are the primary usages of datastage tool?
What is the purpose of interprocessor stage in server jobs?
Name the different types of Lookups in Datastage?