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
Explain connectivity between datastage with datasources?
In Datastage, how you can fix the truncated data error?
Why we use surrogate key?
Can you explain engine tier in information server?
options available in sequence job to run,validate?
root tree will find which is server job and which is parallel job?
What is usage analysis in datastage?
What are data elements?
What a datastage macro?
Can we use target hash file as a lookup ?
Describe routines in datastage? Enlist various types of routines.
What all are the different way to run a job?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How many types of views are there in a datastage director?
Is the value of staging variable stored temporarily or permanently?