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
- 18083 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / kiran
If you want the SCD stage to generate new surrogate keys by
using a key source that you created with a Surrogate Key
Generator stage, you must use the NextSurrogateKey function
to derive the Surrogate Key column.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the difference between odbc and drs stage?
How to RD using transformer?
How to clean the datastage repository?
How you can fix the truncated data error in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between hashfile and sequential file?
State the difference between an operational datastage and a data warehouse?
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...
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the types of containers?
What are the repository tables in datastage?
In Datastage, how you can fix the truncated data error?
