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
- 17836 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
How many Key we can define in remove duplicate stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are datastage sequences?
What is a datastage job?
What is size of a transaction and an array means in a datastage?
Define oconv () and iconv () functions in datastage?
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
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are the different types of lookups in datastage?
How to manage date conversion in Datastage?
Define APT_CONFIG in Datastage?
Differentiate between odbc and drs stage?
What could be a data source system?
How can one find bugs in job sequence?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
