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
- 16356 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 can you write parallel routines in datastage PX?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the types of containers in datastage?
Enlist various types of routines in datastage.
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
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...
What could be a data source system?
What is a quality stage in datastage tool?
What all are the different way to run a job?
What are the partitioning techniques available in link partitioner?
Explain Quality stage?
What are the types of containers?
How you can fix the truncated data error in datastage?
