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 / madhav
canu give ans in depth
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many Key we can define in remove duplicate stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you filter data in hashed file?
Can you implement SCD2 using join, transformer and funnel stage?
What are the types of jobs we have in datastage?
project Steps,hits, Project level HArd things,Solved methods?
Is it possible to query a hash file?
What are the different common services in datastage?
What is the difference between Datastage 7.5 and 7.0?
options available in sequence job to run,validate?
How to manage date conversion in Datastage?
what is repositery?
What is job control?
Define Routines and their types?