Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18084 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
Name the different types of Lookups in Datastage?
What is a quality stage in datastage tool?
Different ways a project can be moved to production ?...example ….export-import and Version control.
what is the use of surogate key in datastage
Differentiate between datastage and datastage tx?
What is active and passive stage?
What is difference between join, merge and lookup stage?
What is usage analysis in datastage?
How do you remove duplicate values in datastage?
What is the difference between in process and inter process?
Differentiate between hash file and sequential file?
What is the use of hoursfromtime() function in transformer stage in datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How to Remove Duplicate using SQL?
how to export or import the jobs in .ISX file
